2025-04-02 01:46:02 Using queries from '/repo/tests/queries' directory 2025-04-02 01:46:02 Connecting to ClickHouse server... OK 2025-04-02 01:46:02 Connected to server 24.12.2.20221.altinityantalya @ 82252d159dc02cab0f366aaa5691adc1545dd11d HEAD 2025-04-02 01:46:02 Found 1667 parallel tests and 130 sequential tests 2025-04-02 01:46:02 Running about 208 stateless tests (Process-5). 2025-04-02 01:46:02 01017_uniqCombined_memory_usage: [ SKIPPED ] 0.00 sec. 2025-04-02 01:46:02 Reason: not running for current build 2025-04-02 01:46:03 Running about 208 stateless tests (Process-3). 2025-04-02 01:46:03 02095_function_get_os_kernel_version: [ OK ] 0.89 sec. 2025-04-02 01:46:04 Running about 208 stateless tests (Process-7). 2025-04-02 01:46:04 02999_analyzer_preimage_null: [ OK ] 1.24 sec. 2025-04-02 01:46:04 Running about 208 stateless tests (Process-6). 2025-04-02 01:46:04 03010_view_prewhere_in: [ OK ] 1.34 sec. 2025-04-02 01:46:04 Running about 208 stateless tests (Process-9). 2025-04-02 01:46:04 00508_materialized_view_to: [ OK ] 1.39 sec. 2025-04-02 01:46:04 00950_bad_alloc_when_truncate_join_storage: [ OK ] 0.76 sec. 2025-04-02 01:46:05 Running about 208 stateless tests (Process-8). 2025-04-02 01:46:05 02491_part_log_has_table_uuid: [ OK ] 2.34 sec. 2025-04-02 01:46:06 00161_rounding_functions: [ OK ] 3.30 sec. 2025-04-02 01:46:06 00468_array_join_multiple_arrays_and_use_original_column: [ OK ] 0.98 sec. 2025-04-02 01:46:06 02400_memory_accounting_on_error: [ OK ] 2.38 sec. 2025-04-02 01:46:07 00098_j_union_all: [ OK ] 0.93 sec. 2025-04-02 01:46:08 01220_scalar_optimization_in_alter: [ OK ] 0.93 sec. 2025-04-02 01:46:09 02922_respect_nulls_parser: [ OK ] 5.29 sec. 2025-04-02 01:46:09 01788_update_nested_type_subcolumn_check: [ OK ] 3.44 sec. 2025-04-02 01:46:09 00205_emptyscalar_subquery_type_mismatch_bug: [ OK ] 1.09 sec. 2025-04-02 01:46:10 Running about 208 stateless tests (Process-4). 2025-04-02 01:46:10 01054_random_printable_ascii_ubsan: [ OK ] 7.82 sec. 2025-04-02 01:46:11 02097_initializeAggregationNullable: [ OK ] 1.03 sec. 2025-04-02 01:46:11 00417_kill_query: [ OK ] 7.39 sec. 2025-04-02 01:46:11 01326_hostname_alias: [ OK ] 0.88 sec. 2025-04-02 01:46:12 00118_storage_join: [ OK ] 1.73 sec. 2025-04-02 01:46:12 02881_system_detached_parts_modification_time: [ OK ] 1.08 sec. 2025-04-02 01:46:12 00534_exp10: [ OK ] 0.98 sec. 2025-04-02 01:46:13 Running about 208 stateless tests (Process-10). 2025-04-02 01:46:13 01165_lost_part_empty_partition: [ OK ] 10.26 sec. 2025-04-02 01:46:13 02125_constant_if_condition_and_not_existing_column: [ OK ] 1.18 sec. 2025-04-02 01:46:14 00143_number_classification_functions: [ OK ] 1.53 sec. 2025-04-02 01:46:14 02724_persist_interval_type: [ OK ] 1.38 sec. 2025-04-02 01:46:15 00841_temporary_table_database: [ OK ] 1.33 sec. 2025-04-02 01:46:15 02354_tuple_element_with_default: [ OK ] 1.08 sec. 2025-04-02 01:46:16 02813_func_now_and_alias: [ OK ] 1.03 sec. 2025-04-02 01:46:16 02584_compressor_codecs: [ OK ] 3.24 sec. 2025-04-02 01:46:16 02859_replicated_db_name_zookeeper: [ OK ] 6.85 sec. 2025-04-02 01:46:17 02841_join_filter_set_sparse: [ OK ] 1.58 sec. 2025-04-02 01:46:17 02474_fix_function_parser_bug: [ OK ] 0.68 sec. 2025-04-02 01:46:17 01293_pretty_max_value_width: [ OK ] 1.53 sec. 2025-04-02 01:46:18 02203_shebang: [ OK ] 2.44 sec. 2025-04-02 01:46:18 01669_test_toYear_mysql_dialect: [ OK ] 0.88 sec. 2025-04-02 01:46:19 03068_analyzer_distributed_join: [ OK ] 1.49 sec. 2025-04-02 01:46:20 00131_set_hashed: [ OK ] 0.88 sec. 2025-04-02 01:46:20 02353_translate: [ OK ] 1.94 sec. 2025-04-02 01:46:21 02444_async_broken_outdated_part_loading: [ OK ] 15.22 sec. 2025-04-02 01:46:22 00275_shard_quantiles_weighted: [ OK ] 2.19 sec. 2025-04-02 01:46:22 01825_type_json_mutations: [ OK ] 1.43 sec. 2025-04-02 01:46:23 00507_array_no_params: [ OK ] 4.64 sec. 2025-04-02 01:46:24 01825_type_json_nbagames: [ OK ] 19.87 sec. 2025-04-02 01:46:24 01531_query_log_query_comment: [ OK ] 3.60 sec. 2025-04-02 01:46:24 02476_fix_cast_parser_bug: [ OK ] 0.68 sec. 2025-04-02 01:46:25 01214_point_in_Mecca: [ OK ] 8.81 sec. 2025-04-02 01:46:25 00335_bom: [ OK ] 1.83 sec. 2025-04-02 01:46:25 00098_shard_i_union_all: [ OK ] 1.39 sec. 2025-04-02 01:46:26 01281_sum_nullable: [ OK ] 1.09 sec. 2025-04-02 01:46:26 03037_dynamic_merges_2_horizontal_wide_merge_tree: [ SKIPPED ] 0.00 sec. 2025-04-02 01:46:26 Reason: not running for current build 2025-04-02 01:46:26 01903_http_fields: [ OK ] 3.89 sec. 2025-04-02 01:46:26 03223_system_tables_set_not_ready: [ OK ] 1.63 sec. 2025-04-02 01:46:28 03202_dynamic_null_map_subcolumn: [ OK ] 5.10 sec. 2025-04-02 01:46:29 02907_clickhouse_dictionary_bug: [ OK ] 2.79 sec. 2025-04-02 01:46:29 00551_parse_or_null: [ OK ] 1.03 sec. 2025-04-02 01:46:30 01036_union_different_columns: [ OK ] 1.08 sec. 2025-04-02 01:46:30 03231_alter_no_properties_before_remove_modify_reset: [ OK ] 5.34 sec. 2025-04-02 01:46:30 03034_dynamic_conversions: [ OK ] 4.79 sec. 2025-04-02 01:46:31 03069_analyzer_with_alias_in_array_join: [ OK ] 0.88 sec. 2025-04-02 01:46:31 01087_index_set_ubsan: [ OK ] 0.99 sec. 2025-04-02 01:46:32 02129_add_column_add_ttl: [ OK ] 1.79 sec. 2025-04-02 01:46:32 01018_Distributed__shard_num: [ OK ] 2.94 sec. 2025-04-02 01:46:32 01123_parse_date_time_best_effort_even_more: [ OK ] 0.94 sec. 2025-04-02 01:46:32 02513_broken_datetime64_init_on_mac: [ OK ] 0.88 sec. 2025-04-02 01:46:33 02809_has_subsequence: [ OK ] 2.24 sec. 2025-04-02 01:46:33 03175_sparse_and_skip_index: [ OK ] 1.58 sec. 2025-04-02 01:46:34 00666_uniq_complex_types: [ OK ] 1.94 sec. 2025-04-02 01:46:35 02354_vector_search_legacy_index_compatibility: [ OK ] 1.99 sec. 2025-04-02 01:46:36 02889_print_pretty_type_names: [ OK ] 1.04 sec. 2025-04-02 01:46:37 02442_auxiliary_zookeeper_endpoint_id: [ OK ] 1.44 sec. 2025-04-02 01:46:38 00953_constraints_operations: [ OK ] 11.41 sec. 2025-04-02 01:46:38 00964_bloom_index_string_functions: [ OK ] 28.96 sec. 2025-04-02 01:46:38 03208_array_of_json_read_subcolumns_2_compact_merge_tree: [ SKIPPED ] 0.00 sec. 2025-04-02 01:46:38 Reason: not running for current build 2025-04-02 01:46:38 01271_show_privileges: [ OK ] 0.94 sec. 2025-04-02 01:46:39 02571_local_desc_abort_on_twitter_json: [ OK ] 4.14 sec. 2025-04-02 01:46:40 03199_queries_with_new_analyzer: [ OK ] 1.29 sec. 2025-04-02 01:46:40 02029_quantile_sanitizer: [ OK ] 1.39 sec. 2025-04-02 01:46:41 01050_engine_join_crash: [ OK ] 2.09 sec. 2025-04-02 01:46:41 02384_analyzer_dict_get_join_get: [ OK ] 3.04 sec. 2025-04-02 01:46:41 02241_short_circuit_short_column: [ OK ] 0.95 sec. 2025-04-02 01:46:42 01017_bithamming_distance: [ OK ] 1.39 sec. 2025-04-02 01:46:43 01072_drop_temporary_table_with_same_name: [ OK ] 1.69 sec. 2025-04-02 01:46:43 03008_deduplication_insert_into_partitioned_table: [ OK ] 3.14 sec. 2025-04-02 01:46:43 02418_keeper_map_keys_limit: [ OK ] 2.14 sec. 2025-04-02 01:46:44 02691_multiple_joins_backtick_identifiers: [ OK ] 1.19 sec. 2025-04-02 01:46:44 01710_projections_group_by_no_key: [ OK ] 1.19 sec. 2025-04-02 01:46:44 02255_broken_parts_chain_on_start: [ OK ] 17.87 sec. 2025-04-02 01:46:45 02973_dictionary_table_exception_fix: [ OK ] 1.70 sec. 2025-04-02 01:46:45 02967_parallel_replicas_joins_and_analyzer: [ OK ] 11.81 sec. 2025-04-02 01:46:46 00609_prewhere_and_default: [ OK ] 2.29 sec. 2025-04-02 01:46:47 03230_show_create_query_identifier_quoting_style: [ OK ] 2.69 sec. 2025-04-02 01:46:47 00732_quorum_insert_simple_test_1_parts_zookeeper_long: [ OK ] 1.79 sec. 2025-04-02 01:46:48 00426_nulls_sorting: [ OK ] 1.44 sec. 2025-04-02 01:46:49 03012_parser_backtracking: [ OK ] 34.86 sec. 2025-04-02 01:46:49 03144_invalid_filter: [ OK ] 1.94 sec. 2025-04-02 01:46:50 02458_datediff_date32: [ OK ] 3.34 sec. 2025-04-02 01:46:50 00914_replicate: [ OK ] 0.94 sec. 2025-04-02 01:46:50 01104_distributed_numbers_test: [ OK ] 1.39 sec. 2025-04-02 01:46:51 03064_analyzer_named_subqueries: [ OK ] 0.85 sec. 2025-04-02 01:46:51 01678_great_circle_angle: [ OK ] 1.34 sec. 2025-04-02 01:46:52 00180_attach_materialized_view: [ OK ] 1.08 sec. 2025-04-02 01:46:52 00839_bitmask_negative: [ OK ] 1.51 sec. 2025-04-02 01:46:54 01049_join_low_card_crash: [ OK ] 2.73 sec. 2025-04-02 01:46:55 01230_join_get_truncate: [ OK ] 2.20 sec. 2025-04-02 01:46:57 00853_join_with_nulls_crash: [ OK ] 2.29 sec. 2025-04-02 01:46:58 00152_totals_in_subquery: [ OK ] 1.23 sec. 2025-04-02 01:46:59 01445_create_table_as_table_function: [ OK ] 4.01 sec. 2025-04-02 01:47:00 03276_index_of_assume_sorted: [ OK ] 2.08 sec. 2025-04-02 01:47:01 02842_suggest_http_page_in_error_message: [ OK ] 1.92 sec. 2025-04-02 01:47:02 01720_union_distinct_with_limit: [ OK ] 1.04 sec. 2025-04-02 01:47:04 03273_better_json_subcolumns_parsing: [ OK ] 1.38 sec. 2025-04-02 01:47:05 00369_int_div_of_float: [ OK ] 1.21 sec. 2025-04-02 01:47:12 03008_azure_plain_rewritable_with_slash: [ OK ] 26.85 sec. 2025-04-02 01:47:12 01753_mutate_table_predicated_with_table: [ OK ] 6.25 sec. 2025-04-02 01:47:12 00945_bloom_filter_index: [ OK ] 29.75 sec. 2025-04-02 01:47:13 02180_group_by_lowcardinality: [ OK ] 0.84 sec. 2025-04-02 01:47:13 00059_shard_global_in: [ OK ] 1.19 sec. 2025-04-02 01:47:13 02963_remote_read_small_buffer_size_bug: [ OK ] 40.84 sec. 2025-04-02 01:47:13 02933_group_by_memory_usage: [ OK ] 25.00 sec. 2025-04-02 01:47:14 02422_read_numbers_as_strings: [ OK ] 0.99 sec. 2025-04-02 01:47:14 00753_distributed_system_columns_and_system_tables: [ OK ] 1.24 sec. 2025-04-02 01:47:14 00968_roundAge: [ OK ] 1.09 sec. 2025-04-02 01:47:14 01710_projection_drop_if_exists: [ OK ] 1.49 sec. 2025-04-02 01:47:15 01710_normal_projection_format: [ OK ] 0.99 sec. 2025-04-02 01:47:16 01504_rocksdb: [ OK ] 31.73 sec. 2025-04-02 01:47:16 02412_nlp: [ OK ] 1.39 sec. 2025-04-02 01:47:17 02176_optimize_aggregation_in_order_empty: [ OK ] 1.24 sec. 2025-04-02 01:47:18 02477_invalid_reads: [ OK ] 17.11 sec. 2025-04-02 01:47:18 02311_create_table_with_unknown_format: [ OK ] 3.20 sec. 2025-04-02 01:47:19 01804_uniq_up_to_ubsan: [ OK ] 1.44 sec. 2025-04-02 01:47:20 01104_fixed_string_like: [ OK ] 2.39 sec. 2025-04-02 01:47:20 01699_timezoneOffset: [ OK ] 2.95 sec. 2025-04-02 01:47:20 02902_add_scalar_in_all_case: [ OK ] 1.14 sec. 2025-04-02 01:47:21 00098_g_union_all: [ OK ] 0.95 sec. 2025-04-02 01:47:21 02523_range_const_start: [ OK ] 0.95 sec. 2025-04-02 01:47:23 02507_to_unix_timestamp_overflow: [ OK ] 2.29 sec. 2025-04-02 01:47:23 03020_output_format_client: [ OK ] 7.96 sec. 2025-04-02 01:47:24 02294_dictionaries_hierarchical_index: [ OK ] 2.39 sec. 2025-04-02 01:47:24 00443_optimize_final_vertical_merge: [ OK ] 31.90 sec. 2025-04-02 01:47:25 02234_position_case_insensitive_utf8: [ OK ] 0.94 sec. 2025-04-02 01:47:25 01063_create_column_set: [ OK ] 1.04 sec. 2025-04-02 01:47:25 02579_parameterized_replace: [ OK ] 1.00 sec. 2025-04-02 01:47:27 01670_distributed_bytes_to_throw_insert: [ OK ] 1.75 sec. 2025-04-02 01:47:28 01072_json_each_row_data_in_square_brackets: [ OK ] 1.09 sec. 2025-04-02 01:47:29 01927_query_views_log_current_database: [ OK ] 5.61 sec. 2025-04-02 01:47:29 01089_alter_settings_old_format: [ OK ] 1.45 sec. 2025-04-02 01:47:30 01913_names_of_tuple_literal: [ OK ] 1.01 sec. 2025-04-02 01:47:31 02950_parallel_replicas_used_count: [ OK ] 10.22 sec. 2025-04-02 01:47:31 01680_date_time_add_ubsan: [ OK ] 1.96 sec. 2025-04-02 01:47:33 02125_lz4_compression_bug_JSONCompactEachRow: [ OK ] 18.95 sec. 2025-04-02 01:47:33 01894_jit_aggregation_function_max_long: [ OK ] 2.76 sec. 2025-04-02 01:47:33 02433_default_expression_operator_in: [ OK ] 2.26 sec. 2025-04-02 01:47:34 02417_null_variadic_behaviour: [ OK ] 2.99 sec. 2025-04-02 01:47:34 01640_distributed_async_insert_compression: [ OK ] 1.19 sec. 2025-04-02 01:47:34 03196_max_intersections_arena_crash: [ OK ] 1.09 sec. 2025-04-02 01:47:35 00938_dataset_test: [ OK ] 1.26 sec. 2025-04-02 01:47:35 00860_unknown_identifier_bug: [ OK ] 1.14 sec. 2025-04-02 01:47:35 00113_shard_group_array: [ OK ] 23.40 sec. 2025-04-02 01:47:36 02680_datetime64_monotonic_check: [ OK ] 1.40 sec. 2025-04-02 01:47:36 01702_rewrite_avg_for_algebraic_optimization: [ OK ] 1.49 sec. 2025-04-02 01:47:36 02324_map_combinator_bug: [ OK ] 1.54 sec. 2025-04-02 01:47:37 01444_create_table_drop_database_race: [ OK ] 12.39 sec. 2025-04-02 01:47:37 03251_unaligned_window_function_state: [ OK ] 1.30 sec. 2025-04-02 01:47:38 02296_nullable_arguments_in_array_filter: [ OK ] 1.04 sec. 2025-04-02 01:47:38 01410_nullable_key_and_index_negate_cond: [ OK ] 1.84 sec. 2025-04-02 01:47:38 01937_nested_chinese: [ OK ] 1.14 sec. 2025-04-02 01:47:39 01925_json_as_string_data_in_square_brackets: [ OK ] 1.09 sec. 2025-04-02 01:47:39 03040_dynamic_type_alters_1_wide_merge_tree: [ OK ] 4.01 sec. 2025-04-02 01:47:40 02112_skip_index_set_and_or: [ OK ] 1.05 sec. 2025-04-02 01:47:40 02864_statistics_predicates: [ OK ] 14.89 sec. 2025-04-02 01:47:41 02737_sql_auto_is_null: [ OK ] 0.94 sec. 2025-04-02 01:47:41 00910_decimal_group_array_crash_3783: [ OK ] 1.74 sec. 2025-04-02 01:47:42 01428_hash_set_nan_key: [ OK ] 1.14 sec. 2025-04-02 01:47:43 00925_zookeeper_empty_replicated_merge_tree_optimize_final_long: [ OK ] 7.46 sec. 2025-04-02 01:47:43 03206_no_exceptions_clickhouse_local: [ FAIL ] 2.45 sec. 2025-04-02 01:47:43 Reason: return code: 134, result: 2025-04-02 01:47:43 2025-04-02 01:47:43 2025-04-02 01:47:43 2025-04-02 01:47:43 stdout: 2025-04-02 01:47:43 2025-04-02 01:47:43 2025-04-02 01:47:43 Settings used in the test: --max_insert_threads 3 --group_by_two_level_threshold 185904 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 1771189 --max_read_buffer_size 986978 --prefer_localhost_replica 1 --max_block_size 89292 --max_joined_block_size_rows 73638 --max_threads 2 --optimize_append_index 0 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 22 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 26247284 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 1 --min_bytes_to_use_mmap_io 4537774975 --local_filesystem_read_method io_uring --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 0 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 28 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 561924549 --min_compress_block_size 400311 --max_compress_block_size 657416 --merge_tree_compact_parts_min_granules_to_multibuffer_read 8 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 5519287 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 0 --session_timezone America/Hermosillo --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.0 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 1 --max_parsing_threads 0 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table true --output_format_native_write_json_as_string 1 --enable_vertical_final 1 2025-04-02 01:47:43 2025-04-02 01:47:43 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.9361264831383767 --prefer_fetch_merged_part_size_threshold 4644527172 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 5238127 --merge_max_block_size 10337 --index_granularity 35600 --min_bytes_for_wide_part 0 --marks_compress_block_size 88704 --primary_key_compress_block_size 27702 --replace_long_file_name_to_hash 1 --max_file_name_length 42 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 119913672 --compact_parts_max_granules_to_buffer 193 --compact_parts_merge_max_bytes_to_prefetch_part 32978235 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 100 --old_parts_lifetime 401 --prewarm_mark_cache 1 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 1 --use_primary_key_cache 0 --prewarm_primary_key_cache 0 2025-04-02 01:47:43 2025-04-02 01:47:43 Database: test_8jzotoi1 2025-04-02 01:47:43 01079_alter_default_zookeeper_long: [ OK ] 4.95 sec. 2025-04-02 01:47:44 02310_generate_multi_columns_with_uuid: [ OK ] 1.01 sec. 2025-04-02 01:47:45 03258_quantile_exact_weighted_issue: [ OK ] 1.19 sec. 2025-04-02 01:47:45 02122_parallel_formatting_Markdown: [ OK ] 7.66 sec. 2025-04-02 01:47:45 02315_pmj_union_ubsan_35857: [ OK ] 0.89 sec. 2025-04-02 01:47:46 01199_url_functions_path_without_schema_yiurule: [ OK ] 0.94 sec. 2025-04-02 01:47:46 02570_fallback_from_async_insert: [ OK ] 8.96 sec. 2025-04-02 01:47:46 02707_analyzer_nested_lambdas_types: [ OK ] 1.14 sec. 2025-04-02 01:47:47 02899_distributed_limit_by: [ OK ] 4.20 sec. 2025-04-02 01:47:47 01524_do_not_merge_across_partitions_select_final: [ OK ] 4.50 sec. 2025-04-02 01:47:48 00434_tonullable: [ OK ] 0.94 sec. 2025-04-02 01:47:49 02236_json_each_row_empty_map_schema_inference: [ OK ] 0.95 sec. 2025-04-02 01:47:49 03250_client_default_bool_cli_settings_with_no_value_to_true: [ OK ] 3.69 sec. 2025-04-02 01:47:49 01674_clickhouse_client_query_param_cte: [ OK ] 2.64 sec. 2025-04-02 01:47:50 01780_column_sparse_full: [ OK ] 4.20 sec. 2025-04-02 01:47:51 00619_extract: [ OK ] 1.29 sec. 2025-04-02 01:47:52 01549_low_cardinality_mv_fuzz: [ OK ] 1.14 sec. 2025-04-02 01:47:53 01411_xor_itai_shirav: [ OK ] 0.89 sec. 2025-04-02 01:47:54 02423_insert_stats_behaviour: [ OK ] 14.12 sec. 2025-04-02 01:47:54 01576_if_null_external_aggregation: [ OK ] 7.71 sec. 2025-04-02 01:47:54 01657_test_toHour_mysql_compatibility: [ OK ] 0.94 sec. 2025-04-02 01:47:56 02841_not_ready_set_bug: [ OK ] 9.36 sec. 2025-04-02 01:47:56 03156_nullable_number_tips: [ OK ] 1.59 sec. 2025-04-02 01:47:57 00209_insert_select_extremes: [ OK ] 1.19 sec. 2025-04-02 01:47:57 00926_zookeeper_adaptive_index_granularity_replicated_merge_tree_long: [ OK ] 8.11 sec. 2025-04-02 01:47:57 03209_json_type_horizontal_merges: [ SKIPPED ] 0.00 sec. 2025-04-02 01:47:57 Reason: not running for current build 2025-04-02 01:47:57 01652_ttl_old_syntax: [ OK ] 1.34 sec. 2025-04-02 01:47:58 02480_tets_show_full: [ OK ] 3.65 sec. 2025-04-02 01:47:58 00661_array_has_silviucpp: [ OK ] 1.04 sec. 2025-04-02 01:47:58 01787_arena_assert_column_nothing: [ OK ] 0.99 sec. 2025-04-02 01:47:59 00904_array_with_constant_2: [ OK ] 1.11 sec. 2025-04-02 01:48:00 01825_new_type_json_in_array: [ OK ] 2.60 sec. 2025-04-02 01:48:05 02560_vertical_merge_memory_usage: [ OK ] 15.49 sec. 2025-04-02 01:48:05 02718_parquet_metadata_format: [ OK ] 10.76 sec. 2025-04-02 01:48:08 01273_arrow_nested_arrays_load: [ OK ] 9.43 sec. 2025-04-02 01:48:09 00842_array_with_constant_overflow: [ OK ] 3.08 sec. 2025-04-02 01:48:10 02718_cli_dashed_options_parsing: [ OK ] 12.03 sec. 2025-04-02 01:48:12 01301_polygons_within: [ OK ] 3.20 sec. 2025-04-02 01:48:13 00368_format_option_collision: [ OK ] 5.23 sec. 2025-04-02 01:48:14 02789_functions_after_sorting_and_columns_with_same_names_bug_2: [ OK ] 3.22 sec. 2025-04-02 01:48:14 02876_yyyymmddtodate: [ OK ] 14.45 sec. 2025-04-02 01:48:15 02693_multiple_joins_in: [ OK ] 2.24 sec. 2025-04-02 01:48:16 00490_special_line_separators_and_characters_outside_of_bmp: [ OK ] 1.83 sec. 2025-04-02 01:48:16 02179_range_hashed_dictionary_invalid_interval: [ OK ] 2.71 sec. 2025-04-02 01:48:17 03033_lightweight_deletes_sync: [ OK ] 2.78 sec. 2025-04-02 01:48:17 02053_INSERT_SELECT_MATERIALIZED: [ OK ] 2.50 sec. 2025-04-02 01:48:20 02245_s3_schema_desc: [ OK ] 3.93 sec. 2025-04-02 01:48:21 03033_analyzer_resolve_from_parent_scope: [ OK ] 3.61 sec. 2025-04-02 01:48:24 02802_clickhouse_disks_s3_copy: [ OK ] 7.59 sec. 2025-04-02 01:48:29 01648_mutations_and_escaping: [ OK ] 8.31 sec. 2025-04-02 01:48:30 00311_array_primary_key: [ OK ] 5.37 sec. 2025-04-02 01:48:31 02461_cancel_finish_race: [ OK ] 31.78 sec. 2025-04-02 01:48:32 01413_alter_update_supertype: [ OK ] 2.35 sec. 2025-04-02 01:48:33 01948_group_bitmap_and_or_xor_fix: [ OK ] 1.29 sec. 2025-04-02 01:48:35 02582_analyzer_join_subquery_empty_column_list: [ OK ] 1.97 sec. 2025-04-02 01:48:37 00700_decimal_in_keys: [ OK ] 2.25 sec. 2025-04-02 01:48:37 01058_window_view_event_hop_to_strict_asc: [ OK ] 15.94 sec. 2025-04-02 01:48:38 03223_interval_data_type_comparison: [ OK ] 8.92 sec. 2025-04-02 01:48:38 02503_in_lc_const_args_bug: [ OK ] 0.99 sec. 2025-04-02 01:48:39 00370_duplicate_columns_in_subqueries: [ OK ] 1.65 sec. 2025-04-02 01:48:39 02515_and_or_if_multiif_not_return_lc: [ OK ] 1.09 sec. 2025-04-02 01:48:40 02493_max_streams_for_merge_tree_reading: [ OK ] 22.97 sec. 2025-04-02 01:48:40 02479_analyzer_aggregation_crash: [ OK ] 1.25 sec. 2025-04-02 01:48:40 01710_minmax_count_projection_distributed_query: [ OK ] 1.24 sec. 2025-04-02 01:48:40 01483_merge_table_join_and_group_by: [ OK ] 2.00 sec. 2025-04-02 01:48:41 02233_with_total_empty_chunk: [ OK ] 1.25 sec. 2025-04-02 01:48:41 01471_with_format: [ OK ] 0.95 sec. 2025-04-02 01:48:42 02566_analyzer_limit_settings_distributed: [ OK ] 1.89 sec. 2025-04-02 01:48:42 03032_rmt_create_columns_from_replica: [ OK ] 1.14 sec. 2025-04-02 01:48:43 02481_default_value_used_in_row_level_filter: [ OK ] 1.49 sec. 2025-04-02 01:48:43 01547_query_log_current_database: [ OK ] 3.05 sec. 2025-04-02 01:48:44 02999_ulid_short_circuit: [ OK ] 0.94 sec. 2025-04-02 01:48:45 02890_untuple_column_names: [ OK ] 2.60 sec. 2025-04-02 01:48:45 02026_accurate_cast_or_default: [ OK ] 3.05 sec. 2025-04-02 01:48:45 00974_full_outer_join: [ OK ] 0.94 sec. 2025-04-02 01:48:46 02540_analyzer_matcher_alias_materialized_columns: [ OK ] 1.39 sec. 2025-04-02 01:48:46 01511_alter_version_versioned_collapsing_merge_tree: [ OK ] 3.15 sec. 2025-04-02 01:48:47 00738_nested_merge_multidimensional_array: [ OK ] 1.24 sec. 2025-04-02 01:48:48 01769_extended_range_2: [ OK ] 1.24 sec. 2025-04-02 01:48:49 01663_quantile_weighted_overflow: [ OK ] 0.94 sec. 2025-04-02 01:48:50 00188_constants_as_arguments_of_aggregate_functions: [ OK ] 0.94 sec. 2025-04-02 01:48:50 01056_predicate_optimizer_bugs: [ OK ] 3.60 sec. 2025-04-02 01:48:51 01831_max_streams: [ OK ] 0.95 sec. 2025-04-02 01:48:51 02176_dict_get_has_implicit_key_cast: [ OK ] 4.55 sec. 2025-04-02 01:48:51 03041_analyzer_gigachad_join: [ OK ] 1.39 sec. 2025-04-02 01:48:52 02811_invalid_embedded_rocksdb_create: [ OK ] 1.30 sec. 2025-04-02 01:48:53 02149_issue_32487: [ OK ] 1.04 sec. 2025-04-02 01:48:54 01651_group_uniq_array_enum: [ OK ] 1.15 sec. 2025-04-02 01:48:55 02661_read_from_archive_targz: [ OK ] 49.59 sec. 2025-04-02 01:48:56 01196_max_parser_depth: [ OK ] 4.25 sec. 2025-04-02 01:48:56 01935_parametrized_query_parametric_aggregate_function: [ OK ] 1.85 sec. 2025-04-02 01:48:57 00743_limit_by_not_found_column: [ OK ] 1.19 sec. 2025-04-02 01:48:58 01880_materialized_view_to_table_type_check: [ OK ] 2.25 sec. 2025-04-02 01:49:00 01784_parallel_formatting_memory: [ OK ] 2.05 sec. 2025-04-02 01:49:00 01910_view_dictionary_check_refresh: [ OK ] 26.89 sec. 2025-04-02 01:49:01 03224_json_merges_new_type_in_shared_data: [ OK ] 1.70 sec. 2025-04-02 01:49:02 00228_shard_quantiles_deterministic_merge_overflow: [ OK ] 1.55 sec. 2025-04-02 01:49:02 02923_join_use_nulls_modulo: [ OK ] 1.04 sec. 2025-04-02 01:49:03 02813_seriesOutliersDetectTukey: [ OK ] 4.65 sec. 2025-04-02 01:49:04 00803_odbc_driver_2_format: [ OK ] 0.99 sec. 2025-04-02 01:49:07 01099_operators_date_and_timestamp: [ OK ] 12.17 sec. 2025-04-02 01:49:08 03279_pr_3_way_joins_left_first: [ OK ] 5.45 sec. 2025-04-02 01:49:08 00619_union_highlite: [ OK ] 1.15 sec. 2025-04-02 01:49:10 02567_native_type_conversions: [ OK ] 8.51 sec. 2025-04-02 01:49:14 02904_empty_order_by_with_setting_enabled: [ OK ] 5.36 sec. 2025-04-02 01:49:14 02812_pointwise_array_operations: [ OK ] 3.90 sec. 2025-04-02 01:49:15 01825_new_type_json_9: [ OK ] 1.50 sec. 2025-04-02 01:49:16 02366_kql_func_ip: [ OK ] 11.72 sec. 2025-04-02 01:49:17 00712_prewhere_with_final: [ OK ] 1.45 sec. 2025-04-02 01:49:17 02387_parse_date_as_datetime: [ OK ] 1.29 sec. 2025-04-02 01:49:18 02874_analysis_of_variance_overflow: [ OK ] 1.20 sec. 2025-04-02 01:49:21 02861_alter_replace_partition_do_not_wait_mutations_on_unrelated_partitions: [ OK ] 12.69 sec. 2025-04-02 01:49:26 01505_pipeline_executor_UAF: [ OK ] 40.76 sec. 2025-04-02 01:49:28 01096_zeros: [ OK ] 1.61 sec. 2025-04-02 01:49:31 03221_merge_profile_events: [ OK ] 13.04 sec. 2025-04-02 01:49:31 02790_url_multiple_tsv_files: [ OK ] 10.51 sec. 2025-04-02 01:49:33 03199_fix_auc_tie_handling: [ OK ] 1.42 sec. 2025-04-02 01:49:34 03032_save_bad_json_escape_sequences: [ OK ] 0.85 sec. 2025-04-02 01:49:34 02473_multistep_split_prewhere: [ OK ] 105.26 sec. 2025-04-02 01:49:35 00024_unused_array_join_in_subquery: [ OK ] 1.04 sec. 2025-04-02 01:49:36 01509_parallel_quorum_and_merge_long: [ OK ] 21.73 sec. 2025-04-02 01:49:37 00974_fix_join_on: [ OK ] 5.17 sec. 2025-04-02 01:49:37 01019_array_fill: [ OK ] 1.58 sec. 2025-04-02 01:49:38 00196_float32_formatting: [ OK ] 1.31 sec. 2025-04-02 01:49:38 02915_fpc_overflow: [ OK ] 3.36 sec. 2025-04-02 01:49:38 02456_test_zero_copy_mutation: [ OK ] 1.72 sec. 2025-04-02 01:49:38 01456_low_cardinality_sorting_bugfix: [ OK ] 1.77 sec. 2025-04-02 01:49:39 02734_big_int_from_float_ubsan: [ OK ] 1.05 sec. 2025-04-02 01:49:40 00293_shard_max_subquery_depth: [ OK ] 1.80 sec. 2025-04-02 01:49:41 02918_implicit_sign_column_constraints_for_collapsing_engine: [ OK ] 12.85 sec. 2025-04-02 01:49:42 02771_ignore_data_skipping_indices: [ OK ] 3.07 sec. 2025-04-02 01:49:42 02943_variant_element: [ OK ] 1.60 sec. 2025-04-02 01:49:43 01247_least_greatest_filimonov: [ OK ] 1.01 sec. 2025-04-02 01:49:43 03270_object_to_json_alter_wide_merge_tree: [ OK ] 26.30 sec. 2025-04-02 01:49:43 03037_dynamic_merges_1_horizontal_compact_wide_tree: [ SKIPPED ] 0.00 sec. 2025-04-02 01:49:43 Reason: not running for current build 2025-04-02 01:49:45 00447_foreach_modifier: [ OK ] 1.86 sec. 2025-04-02 01:49:46 02357_query_cancellation_race: [ OK ] 8.32 sec. 2025-04-02 01:49:46 02815_no_throw_in_simple_queries: [ FAIL ] 7.29 sec. 2025-04-02 01:49:46 Reason: return code: 1 2025-04-02 01:49:46 expect: spawn id exp3 not open 2025-04-02 01:49:46 while executing 2025-04-02 01:49:46 "expect ":) "" 2025-04-02 01:49:46 , result: 2025-04-02 01:49:46 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 2025-04-02 01:49:46 stdout: 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 Failed 2025-04-02 01:49:46 2025-04-02 01:49:46 2025-04-02 01:49:46 Settings used in the test: --max_insert_threads 1 --group_by_two_level_threshold 822643 --group_by_two_level_threshold_bytes 49099715 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 11884012 --max_read_buffer_size 1040589 --prefer_localhost_replica 0 --max_block_size 63359 --max_joined_block_size_rows 45494 --max_threads 3 --optimize_append_index 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 0 --optimize_or_like_chain 1 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 89 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 26018005 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 4584700339 --local_filesystem_read_method read --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 10 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 16 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 2715374885 --min_compress_block_size 2070 --max_compress_block_size 1473901 --merge_tree_compact_parts_min_granules_to_multibuffer_read 68 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 4491250 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 0 --session_timezone Africa/Juba --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.15 --prefer_external_sort_block_bytes 100000000 --cross_join_min_rows_to_compress 1 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 0 --max_parsing_threads 1 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table false --output_format_native_write_json_as_string 0 --enable_vertical_final 1 2025-04-02 01:49:46 2025-04-02 01:49:46 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 311901 --vertical_merge_algorithm_min_columns_to_activate 18 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 6624936 --merge_max_block_size 4947 --index_granularity 48246 --min_bytes_for_wide_part 311244079 --marks_compress_block_size 50329 --primary_key_compress_block_size 66457 --replace_long_file_name_to_hash 0 --max_file_name_length 64 --min_bytes_for_full_part_storage 533888216 --compact_parts_max_bytes_to_buffer 402852942 --compact_parts_max_granules_to_buffer 248 --compact_parts_merge_max_bytes_to_prefetch_part 27763859 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 0 --old_parts_lifetime 370 --prewarm_mark_cache 1 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 0 --use_primary_key_cache 0 --prewarm_primary_key_cache 1 2025-04-02 01:49:46 2025-04-02 01:49:46 Database: test_u03xerdz 2025-04-02 01:49:46 02572_max_intersections: [ OK ] 1.01 sec. 2025-04-02 01:49:47 03065_analyzer_cross_join_and_array_join: [ OK ] 1.00 sec. 2025-04-02 01:49:47 02361_fsync_profile_events: [ OK ] 6.51 sec. 2025-04-02 01:49:48 01232_untuple: [ OK ] 1.50 sec. 2025-04-02 01:49:50 01032_cityHash64_for_UUID: [ OK ] 2.16 sec. 2025-04-02 01:49:52 01825_new_type_json_bools: [ OK ] 1.90 sec. 2025-04-02 01:49:52 01273_arrow_arrays_load: [ OK ] 9.13 sec. 2025-04-02 01:49:53 02982_comments_in_system_tables: [ OK ] 5.11 sec. 2025-04-02 01:49:56 02280_add_query_level_settings: [ OK ] 3.80 sec. 2025-04-02 01:49:57 03169_modify_column_data_loss: [ OK ] 4.28 sec. 2025-04-02 01:50:00 02898_parallel_replicas_custom_key_final: [ OK ] 3.55 sec. 2025-04-02 01:50:01 02883_zookeeper_finalize_stress: [ OK ] 14.12 sec. 2025-04-02 01:50:01 01416_clear_column_pk: [ OK ] 3.22 sec. 2025-04-02 01:50:02 02355_control_block_size_in_array_join: [ OK ] 1.45 sec. 2025-04-02 01:50:03 03258_nonexistent_db: [ OK ] 2.35 sec. 2025-04-02 01:50:03 01650_expressions_merge_bug: [ OK ] 0.94 sec. 2025-04-02 01:50:04 01559_misplaced_codec_diagnostics: [ OK ] 0.74 sec. 2025-04-02 01:50:04 00623_truncate_table: [ OK ] 3.71 sec. 2025-04-02 01:50:05 01084_regexp_empty: [ OK ] 1.10 sec. 2025-04-02 01:50:06 02494_parser_string_binary_literal: [ OK ] 1.80 sec. 2025-04-02 01:50:07 00826_cross_to_inner_join: [ OK ] 4.25 sec. 2025-04-02 01:50:10 03267_min_parts_to_merge_at_once: [ OK ] 16.94 sec. 2025-04-02 01:50:10 01681_bloom_filter_nullable_column: [ OK ] 3.01 sec. 2025-04-02 01:50:13 02784_disable_async_with_dedup_correctly: [ OK ] 7.42 sec. 2025-04-02 01:50:14 01691_parser_data_type_exponential: [ OK ] 8.51 sec. 2025-04-02 01:50:15 00090_union_race_conditions_1: [ OK ] 83.17 sec. 2025-04-02 01:50:16 03234_replicated_table_parent_znode_cleanup: [ OK ] 5.70 sec. 2025-04-02 01:50:16 03036_dynamic_read_shared_subcolumns_memory: [ SKIPPED ] 0.00 sec. 2025-04-02 01:50:16 Reason: not running for current build 2025-04-02 01:50:16 03158_dynamic_type_from_variant: [ OK ] 1.15 sec. 2025-04-02 01:50:16 02811_csv_input_field_type_mismatch: [ OK ] 5.51 sec. 2025-04-02 01:50:16 02956_clickhouse_local_system_parts: [ OK ] 2.80 sec. 2025-04-02 01:50:17 01851_s2_to_geo: [ OK ] 1.05 sec. 2025-04-02 01:50:17 02554_format_json_columns_for_empty: [ OK ] 1.05 sec. 2025-04-02 01:50:18 01499_log_deadlock: [ OK ] 1.51 sec. 2025-04-02 01:50:18 03167_base64_url_functions_sh: [ OK ] 181.91 sec. 2025-04-02 01:50:18 02381_analyzer_join_final: [ OK ] 1.51 sec. 2025-04-02 01:50:19 03203_variant_convert_field_to_type_bug: [ OK ] 1.45 sec. 2025-04-02 01:50:19 02456_aggregate_state_conversion: [ OK ] 1.05 sec. 2025-04-02 01:50:19 01451_wrong_error_long_query: [ OK ] 2.26 sec. 2025-04-02 01:50:19 03208_numbers_total_rows_approx: [ OK ] 0.99 sec. 2025-04-02 01:50:20 01272_suspicious_codecs: [ OK ] 6.41 sec. 2025-04-02 01:50:20 03084_analyzer_join_column_alias: [ OK ] 1.44 sec. 2025-04-02 01:50:21 02868_operator_is_not_distinct_from_priority: [ OK ] 1.20 sec. 2025-04-02 01:50:21 01528_allow_nondeterministic_optimize_skip_unused_shards: [ OK ] 1.75 sec. 2025-04-02 01:50:22 03167_base64_url_functions: [ OK ] 3.05 sec. 2025-04-02 01:50:22 01514_empty_buffer_different_types: [ OK ] 1.46 sec. 2025-04-02 01:50:22 01308_row_policy_and_trivial_count_query: [ OK ] 1.30 sec. 2025-04-02 01:50:23 01892_setting_limit_offset_distributed: [ OK ] 1.80 sec. 2025-04-02 01:50:24 01601_proxy_protocol: [ OK ] 1.95 sec. 2025-04-02 01:50:24 00195_shard_union_all_and_global_in: [ OK ] 1.70 sec. 2025-04-02 01:50:24 02687_native_fuzz: [ OK ] 1.56 sec. 2025-04-02 01:50:27 02493_inconsistent_hex_and_binary_number: [ OK ] 7.92 sec. 2025-04-02 01:50:28 01419_merge_tree_settings_sanity_check: [ OK ] 3.82 sec. 2025-04-02 01:50:29 02304_grouping_set_order_by: [ OK ] 1.15 sec. 2025-04-02 01:50:29 01283_max_threads_simple_query_optimization: [ OK ] 4.96 sec. 2025-04-02 01:50:31 02242_make_date_mysql: [ OK ] 3.41 sec. 2025-04-02 01:50:32 02810_fix_remove_dedundant_distinct_view: [ OK ] 1.60 sec. 2025-04-02 01:50:33 02841_parallel_final_wrong_columns_order: [ OK ] 8.28 sec. 2025-04-02 01:50:34 01906_partition_by_multiply_by_zero: [ OK ] 1.41 sec. 2025-04-02 01:50:34 00522_multidimensional: [ OK ] 5.46 sec. 2025-04-02 01:50:35 02674_trivial_count_analyzer: [ OK ] 2.63 sec. 2025-04-02 01:50:36 01881_create_as_tuple: [ OK ] 1.40 sec. 2025-04-02 01:50:36 00299_stripe_log_multiple_inserts: [ OK ] 2.05 sec. 2025-04-02 01:50:37 03285_parallel_replicas_one_replica: [ OK ] 1.10 sec. 2025-04-02 01:50:38 00072_in_types: [ OK ] 1.05 sec. 2025-04-02 01:50:38 03039_dynamic_aggregating_merge_tree: [ OK ] 56.21 sec. 2025-04-02 01:50:38 02798_explain_settings_not_applied_bug: [ OK ] 1.30 sec. 2025-04-02 01:50:40 00521_multidimensional: [ OK ] 2.36 sec. 2025-04-02 01:50:40 01700_system_zookeeper_path_in: [ OK ] 1.85 sec. 2025-04-02 01:50:41 02191_parse_date_time_best_effort_more_cases: [ OK ] 1.40 sec. 2025-04-02 01:50:42 01825_new_type_json_insert_select: [ OK ] 3.76 sec. 2025-04-02 01:50:43 03143_group_by_constant_secondary: [ OK ] 1.15 sec. 2025-04-02 01:50:43 03038_nested_dynamic_merges_compact_vertical: [ SKIPPED ] 0.00 sec. 2025-04-02 01:50:43 Reason: not running for current build 2025-04-02 01:50:44 00725_memory_tracking: [ OK ] 2.26 sec. 2025-04-02 01:50:45 03261_test_merge_parquet_bloom_filter_minmax_stats: [ OK ] 4.30 sec. 2025-04-02 01:50:47 02763_row_policy_storage_merge_alias: [ OK ] 2.95 sec. 2025-04-02 01:50:47 01460_line_as_string_format: [ OK ] 25.22 sec. 2025-04-02 01:50:48 01091_insert_with_default_json: [ OK ] 1.35 sec. 2025-04-02 01:50:48 02981_translate_fixedstring: [ OK ] 1.06 sec. 2025-04-02 01:50:50 02429_combinators_in_array_reduce: [ OK ] 1.30 sec. 2025-04-02 01:50:51 01081_demangle: [ OK ] 0.95 sec. 2025-04-02 01:50:51 00969_columns_clause: [ OK ] 2.31 sec. 2025-04-02 01:50:52 00060_date_lut: [ OK ] 0.95 sec. 2025-04-02 01:50:52 02477_logical_expressions_optimizer_low_cardinality: [ OK ] 1.50 sec. 2025-04-02 01:50:52 01103_check_cpu_instructions_at_startup: [ SKIPPED ] 0.00 sec. 2025-04-02 01:50:52 Reason: not running for current build 2025-04-02 01:50:53 02461_prewhere_row_level_policy_lightweight_delete: [ OK ] 8.47 sec. 2025-04-02 01:50:53 02995_index_6: [ SKIPPED ] 0.00 sec. 2025-04-02 01:50:53 Reason: not running for current build 2025-04-02 01:50:53 01655_window_functions_bug: [ OK ] 1.10 sec. 2025-04-02 01:50:56 00534_functions_bad_arguments11: [ OK ] 68.30 sec. 2025-04-02 01:50:56 00506_union_distributed: [ OK ] 2.85 sec. 2025-04-02 01:50:57 01076_json_each_row_array: [ OK ] 3.50 sec. 2025-04-02 01:50:57 02306_window_move_row_number_fix: [ OK ] 1.00 sec. 2025-04-02 01:50:58 00411_merge_tree_where_const_in_set: [ OK ] 1.55 sec. 2025-04-02 01:50:59 00847_multiple_join_same_column: [ OK ] 2.20 sec. 2025-04-02 01:51:00 00063_check_query: [ OK ] 1.70 sec. 2025-04-02 01:51:11 00623_in_partition_key: [ FAIL ] 1.60 sec. 2025-04-02 01:51:11 Reason: return code: 210 2025-04-02 01:51:11 Error on processing query: Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) (version 24.12.2.20221.altinityantalya (altinity build)) 2025-04-02 01:51:11 (query: select 111 from test54378 where part_date = '2018-04-19';) 2025-04-02 01:51:11 , result: 2025-04-02 01:51:11 2025-04-02 01:51:11 2025-04-02 01:51:11 2025-04-02 01:51:11 stdout: 2025-04-02 01:51:11 2025-04-02 01:51:11 2025-04-02 01:51:11 Settings used in the test: --max_insert_threads 2 --group_by_two_level_threshold 817653 --group_by_two_level_threshold_bytes 37230746 --distributed_aggregation_memory_efficient 1 --fsync_metadata 1 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 9115410 --max_read_buffer_size 969163 --prefer_localhost_replica 1 --max_block_size 91963 --max_joined_block_size_rows 11401 --max_threads 3 --optimize_append_index 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 7 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 7760209 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method mmap --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 1 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 12 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 969326698 --min_compress_block_size 157827 --max_compress_block_size 2814302 --merge_tree_compact_parts_min_granules_to_multibuffer_read 59 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 5678096 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 0 --session_timezone Africa/Khartoum --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.55 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 1 --cross_join_min_bytes_to_compress 1 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 1 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 0 --query_plan_join_swap_table auto --output_format_native_write_json_as_string 0 --enable_vertical_final 0 2025-04-02 01:51:11 2025-04-02 01:51:11 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 164695 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 29908463 --merge_max_block_size 17321 --index_granularity 26841 --min_bytes_for_wide_part 0 --marks_compress_block_size 64844 --primary_key_compress_block_size 66198 --replace_long_file_name_to_hash 0 --max_file_name_length 128 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 410876568 --compact_parts_max_granules_to_buffer 37 --compact_parts_merge_max_bytes_to_prefetch_part 15588290 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 0 --old_parts_lifetime 286 --prewarm_mark_cache 0 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 0 --use_primary_key_cache 1 --prewarm_primary_key_cache 1 2025-04-02 01:51:11 2025-04-02 01:51:11 Database: test_ne14vram 2025-04-02 01:51:11 01440_big_int_exotic_casts: [ FAIL ] 4.40 sec. 2025-04-02 01:51:11 Reason: return code: 32 2025-04-02 01:51:11 Error on processing query: Code: 32. DB::Exception: Attempt to read after eof: while receiving packet from localhost:9000. (ATTEMPT_TO_READ_AFTER_EOF) (version 24.12.2.20221.altinityantalya (altinity build)) 2025-04-02 01:51:11 (query: DROP TABLE t;) 2025-04-02 01:51:11 , result: 2025-04-02 01:51:11 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 -0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 -0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 4294967295 4294967295 4294967295 4294967295 2025-04-02 01:51:11 8589934588 8589934588 8589934588 8589934588 2025-04-02 01:51:11 12884901879 12884901879 12884901879 12884901879 2025-04-02 01:51:11 17179869168 17179869168 17179869168 17179869168 2025-04-02 01:51:11 21474836455 21474836455 21474836455 21474836455 2025-04-02 01:51:11 25769803740 25769803740 25769803740 25769803740 2025-04-02 01:51:11 30064771023 30064771023 30064771023 30064771023 2025-04-02 01:51:11 34359738304 34359738304 34359738304 34359738304 2025-04-02 01:51:11 38654705583 38654705583 38654705583 38654705583 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 2025-04-02 01:51:11 18446744073709551612 18446744073709551612 18446744073709551612 18446744073709551612 2025-04-02 01:51:11 18446744073709551607 18446744073709551607 18446744073709551607 18446744073709551607 2025-04-02 01:51:11 18446744073709551600 18446744073709551600 18446744073709551600 18446744073709551600 2025-04-02 01:51:11 18446744073709551591 18446744073709551591 18446744073709551591 18446744073709551591 2025-04-02 01:51:11 18446744073709551580 18446744073709551580 18446744073709551580 18446744073709551580 2025-04-02 01:51:11 18446744073709551567 18446744073709551567 18446744073709551567 18446744073709551567 2025-04-02 01:51:11 18446744073709551552 18446744073709551552 18446744073709551552 18446744073709551552 2025-04-02 01:51:11 18446744073709551535 18446744073709551535 18446744073709551535 18446744073709551535 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639935 -1 -1 115792089237316195423570985008687907853269984665640564039457584007913129639935 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639932 -4 -4 115792089237316195423570985008687907853269984665640564039457584007913129639932 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639927 -9 -9 115792089237316195423570985008687907853269984665640564039457584007913129639927 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639920 -16 -16 115792089237316195423570985008687907853269984665640564039457584007913129639920 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639911 -25 -25 115792089237316195423570985008687907853269984665640564039457584007913129639911 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639900 -36 -36 115792089237316195423570985008687907853269984665640564039457584007913129639900 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639887 -49 -49 115792089237316195423570985008687907853269984665640564039457584007913129639887 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639872 -64 -64 115792089237316195423570985008687907853269984665640564039457584007913129639872 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639855 -81 -81 115792089237316195423570985008687907853269984665640564039457584007913129639855 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 115792089237316195423570985008687907853269984665640564039457584007913129639935 2025-04-02 01:51:11 -4 -4 -4 115792089237316195423570985008687907853269984665640564039457584007913129639932 2025-04-02 01:51:11 -9 -9 -9 115792089237316195423570985008687907853269984665640564039457584007913129639927 2025-04-02 01:51:11 -16 -16 -16 115792089237316195423570985008687907853269984665640564039457584007913129639920 2025-04-02 01:51:11 -25 -25 -25 115792089237316195423570985008687907853269984665640564039457584007913129639911 2025-04-02 01:51:11 -36 -36 -36 115792089237316195423570985008687907853269984665640564039457584007913129639900 2025-04-02 01:51:11 -49 -49 -49 115792089237316195423570985008687907853269984665640564039457584007913129639887 2025-04-02 01:51:11 -64 -64 -64 115792089237316195423570985008687907853269984665640564039457584007913129639872 2025-04-02 01:51:11 -81 -81 -81 115792089237316195423570985008687907853269984665640564039457584007913129639855 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 115792089237316195423570985008687907853269984665640564039457584007913129639935 2025-04-02 01:51:11 -4 -4 -4 115792089237316195423570985008687907853269984665640564039457584007913129639932 2025-04-02 01:51:11 -9 -9 -9 115792089237316195423570985008687907853269984665640564039457584007913129639927 2025-04-02 01:51:11 -16 -16 -16 115792089237316195423570985008687907853269984665640564039457584007913129639920 2025-04-02 01:51:11 -25 -25 -25 115792089237316195423570985008687907853269984665640564039457584007913129639911 2025-04-02 01:51:11 -36 -36 -36 115792089237316195423570985008687907853269984665640564039457584007913129639900 2025-04-02 01:51:11 -49 -49 -49 115792089237316195423570985008687907853269984665640564039457584007913129639887 2025-04-02 01:51:11 -64 -64 -64 115792089237316195423570985008687907853269984665640564039457584007913129639872 2025-04-02 01:51:11 -81 -81 -81 115792089237316195423570985008687907853269984665640564039457584007913129639855 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 115792089237316195423570985008687907853269984665640564039457584007913129639935 2025-04-02 01:51:11 -4 -4 -4 115792089237316195423570985008687907853269984665640564039457584007913129639932 2025-04-02 01:51:11 -9 -9 -9 115792089237316195423570985008687907853269984665640564039457584007913129639927 2025-04-02 01:51:11 -16 -16 -16 115792089237316195423570985008687907853269984665640564039457584007913129639920 2025-04-02 01:51:11 -25 -25 -25 115792089237316195423570985008687907853269984665640564039457584007913129639911 2025-04-02 01:51:11 -36 -36 -36 115792089237316195423570985008687907853269984665640564039457584007913129639900 2025-04-02 01:51:11 -49 -49 -49 115792089237316195423570985008687907853269984665640564039457584007913129639887 2025-04-02 01:51:11 -64 -64 -64 115792089237316195423570985008687907853269984665640564039457584007913129639872 2025-04-02 01:51:11 -81 -81 -81 115792089237316195423570985008687907853269984665640564039457584007913129639855 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 115792089237316195423570985008687907853269984665640564039457584007913129639935 2025-04-02 01:51:11 -4 -4 -4 115792089237316195423570985008687907853269984665640564039457584007913129639932 2025-04-02 01:51:11 -9 -9 -9 115792089237316195423570985008687907853269984665640564039457584007913129639927 2025-04-02 01:51:11 -16 -16 -16 115792089237316195423570985008687907853269984665640564039457584007913129639920 2025-04-02 01:51:11 -25 -25 -25 115792089237316195423570985008687907853269984665640564039457584007913129639911 2025-04-02 01:51:11 -36 -36 -36 115792089237316195423570985008687907853269984665640564039457584007913129639900 2025-04-02 01:51:11 -49 -49 -49 115792089237316195423570985008687907853269984665640564039457584007913129639887 2025-04-02 01:51:11 -64 -64 -64 115792089237316195423570985008687907853269984665640564039457584007913129639872 2025-04-02 01:51:11 -81 -81 -81 115792089237316195423570985008687907853269984665640564039457584007913129639855 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 115792089237316195423570985008687907853269984665640564039457584007913129639935 2025-04-02 01:51:11 -4 -4 -4 115792089237316195423570985008687907853269984665640564039457584007913129639932 2025-04-02 01:51:11 -9 -9 -9 115792089237316195423570985008687907853269984665640564039457584007913129639927 2025-04-02 01:51:11 -16 -16 -16 115792089237316195423570985008687907853269984665640564039457584007913129639920 2025-04-02 01:51:11 -25 -25 -25 115792089237316195423570985008687907853269984665640564039457584007913129639911 2025-04-02 01:51:11 -36 -36 -36 115792089237316195423570985008687907853269984665640564039457584007913129639900 2025-04-02 01:51:11 -49 -49 -49 115792089237316195423570985008687907853269984665640564039457584007913129639887 2025-04-02 01:51:11 -64 -64 -64 115792089237316195423570985008687907853269984665640564039457584007913129639872 2025-04-02 01:51:11 -81 -81 -81 115792089237316195423570985008687907853269984665640564039457584007913129639855 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 115792089237316195423570985008687907853269984665640564039457584007913129639935 2025-04-02 01:51:11 -4 -4 -4 115792089237316195423570985008687907853269984665640564039457584007913129639932 2025-04-02 01:51:11 -9 -9 -9 115792089237316195423570985008687907853269984665640564039457584007913129639927 2025-04-02 01:51:11 -16 -16 -16 115792089237316195423570985008687907853269984665640564039457584007913129639920 2025-04-02 01:51:11 -25 -25 -25 115792089237316195423570985008687907853269984665640564039457584007913129639911 2025-04-02 01:51:11 -36 -36 -36 115792089237316195423570985008687907853269984665640564039457584007913129639900 2025-04-02 01:51:11 -49 -49 -49 115792089237316195423570985008687907853269984665640564039457584007913129639887 2025-04-02 01:51:11 -64 -64 -64 115792089237316195423570985008687907853269984665640564039457584007913129639872 2025-04-02 01:51:11 -81 -81 -81 115792089237316195423570985008687907853269984665640564039457584007913129639855 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 1 0 0 0 2025-04-02 01:51:11 2 0 0 0 2025-04-02 01:51:11 3 0 0 0 2025-04-02 01:51:11 4 0 0 0 2025-04-02 01:51:11 5 0 0 0 2025-04-02 01:51:11 6 0 0 0 2025-04-02 01:51:11 7 0 0 0 2025-04-02 01:51:11 8 0 0 0 2025-04-02 01:51:11 9 0 0 0 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 -1 0 0 0 2025-04-02 01:51:11 -2 0 0 0 2025-04-02 01:51:11 -3 0 0 0 2025-04-02 01:51:11 -4 0 0 0 2025-04-02 01:51:11 -5 0 0 0 2025-04-02 01:51:11 -6 0 0 0 2025-04-02 01:51:11 -7 0 0 0 2025-04-02 01:51:11 -8 0 0 0 2025-04-02 01:51:11 -9 0 0 0 2025-04-02 01:51:11 2499500025000000 2499500025000000 2499500025000000 2499500025000000 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 2025-04-02 01:51:11 stdout: 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 1 1 1 1 1 2025-04-02 01:51:11 8 8 8 8 8 2025-04-02 01:51:11 27 27 27 27 27 2025-04-02 01:51:11 64 64 64 64 64 2025-04-02 01:51:11 125 125 125 125 125 2025-04-02 01:51:11 216 216 216 216 216 2025-04-02 01:51:11 343 343 343 343 343 2025-04-02 01:51:11 512 512 512 512 512 2025-04-02 01:51:11 729 729 729 729 729 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 -0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 -0 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 -1 -1 2025-04-02 01:51:11 -4 -4 -4 -4 -4 2025-04-02 01:51:11 -9 -9 -9 -9 -9 2025-04-02 01:51:11 -16 -16 -16 -16 -16 2025-04-02 01:51:11 -25 -25 -25 -25 -25 2025-04-02 01:51:11 -36 -36 -36 -36 -36 2025-04-02 01:51:11 -49 -49 -49 -49 -49 2025-04-02 01:51:11 -64 -64 -64 -64 -64 2025-04-02 01:51:11 -81 -81 -81 -81 -81 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 4294967295 4294967295 4294967295 4294967295 2025-04-02 01:51:11 8589934588 8589934588 8589934588 8589934588 2025-04-02 01:51:11 12884901879 12884901879 12884901879 12884901879 2025-04-02 01:51:11 17179869168 17179869168 17179869168 17179869168 2025-04-02 01:51:11 21474836455 21474836455 21474836455 21474836455 2025-04-02 01:51:11 25769803740 25769803740 25769803740 25769803740 2025-04-02 01:51:11 30064771023 30064771023 30064771023 30064771023 2025-04-02 01:51:11 34359738304 34359738304 34359738304 34359738304 2025-04-02 01:51:11 38654705583 38654705583 38654705583 38654705583 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 18446744073709551615 18446744073709551615 18446744073709551615 18446744073709551615 2025-04-02 01:51:11 18446744073709551612 18446744073709551612 18446744073709551612 18446744073709551612 2025-04-02 01:51:11 18446744073709551607 18446744073709551607 18446744073709551607 18446744073709551607 2025-04-02 01:51:11 18446744073709551600 18446744073709551600 18446744073709551600 18446744073709551600 2025-04-02 01:51:11 18446744073709551591 18446744073709551591 18446744073709551591 18446744073709551591 2025-04-02 01:51:11 18446744073709551580 18446744073709551580 18446744073709551580 18446744073709551580 2025-04-02 01:51:11 18446744073709551567 18446744073709551567 18446744073709551567 18446744073709551567 2025-04-02 01:51:11 18446744073709551552 18446744073709551552 18446744073709551552 18446744073709551552 2025-04-02 01:51:11 18446744073709551535 18446744073709551535 18446744073709551535 18446744073709551535 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639935 -1 -1 115792089237316195423570985008687907853269984665640564039457584007913129639935 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639932 -4 -4 115792089237316195423570985008687907853269984665640564039457584007913129639932 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639927 -9 -9 115792089237316195423570985008687907853269984665640564039457584007913129639927 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639920 -16 -16 115792089237316195423570985008687907853269984665640564039457584007913129639920 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639911 -25 -25 115792089237316195423570985008687907853269984665640564039457584007913129639911 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639900 -36 -36 115792089237316195423570985008687907853269984665640564039457584007913129639900 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639887 -49 -49 115792089237316195423570985008687907853269984665640564039457584007913129639887 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639872 -64 -64 115792089237316195423570985008687907853269984665640564039457584007913129639872 2025-04-02 01:51:11 115792089237316195423570985008687907853269984665640564039457584007913129639855 -81 -81 115792089237316195423570985008687907853269984665640564039457584007913129639855 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 115792089237316195423570985008687907853269984665640564039457584007913129639935 2025-04-02 01:51:11 -4 -4 -4 115792089237316195423570985008687907853269984665640564039457584007913129639932 2025-04-02 01:51:11 -9 -9 -9 115792089237316195423570985008687907853269984665640564039457584007913129639927 2025-04-02 01:51:11 -16 -16 -16 115792089237316195423570985008687907853269984665640564039457584007913129639920 2025-04-02 01:51:11 -25 -25 -25 115792089237316195423570985008687907853269984665640564039457584007913129639911 2025-04-02 01:51:11 -36 -36 -36 115792089237316195423570985008687907853269984665640564039457584007913129639900 2025-04-02 01:51:11 -49 -49 -49 115792089237316195423570985008687907853269984665640564039457584007913129639887 2025-04-02 01:51:11 -64 -64 -64 115792089237316195423570985008687907853269984665640564039457584007913129639872 2025-04-02 01:51:11 -81 -81 -81 115792089237316195423570985008687907853269984665640564039457584007913129639855 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 115792089237316195423570985008687907853269984665640564039457584007913129639935 2025-04-02 01:51:11 -4 -4 -4 115792089237316195423570985008687907853269984665640564039457584007913129639932 2025-04-02 01:51:11 -9 -9 -9 115792089237316195423570985008687907853269984665640564039457584007913129639927 2025-04-02 01:51:11 -16 -16 -16 115792089237316195423570985008687907853269984665640564039457584007913129639920 2025-04-02 01:51:11 -25 -25 -25 115792089237316195423570985008687907853269984665640564039457584007913129639911 2025-04-02 01:51:11 -36 -36 -36 115792089237316195423570985008687907853269984665640564039457584007913129639900 2025-04-02 01:51:11 -49 -49 -49 115792089237316195423570985008687907853269984665640564039457584007913129639887 2025-04-02 01:51:11 -64 -64 -64 115792089237316195423570985008687907853269984665640564039457584007913129639872 2025-04-02 01:51:11 -81 -81 -81 115792089237316195423570985008687907853269984665640564039457584007913129639855 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 115792089237316195423570985008687907853269984665640564039457584007913129639935 2025-04-02 01:51:11 -4 -4 -4 115792089237316195423570985008687907853269984665640564039457584007913129639932 2025-04-02 01:51:11 -9 -9 -9 115792089237316195423570985008687907853269984665640564039457584007913129639927 2025-04-02 01:51:11 -16 -16 -16 115792089237316195423570985008687907853269984665640564039457584007913129639920 2025-04-02 01:51:11 -25 -25 -25 115792089237316195423570985008687907853269984665640564039457584007913129639911 2025-04-02 01:51:11 -36 -36 -36 115792089237316195423570985008687907853269984665640564039457584007913129639900 2025-04-02 01:51:11 -49 -49 -49 115792089237316195423570985008687907853269984665640564039457584007913129639887 2025-04-02 01:51:11 -64 -64 -64 115792089237316195423570985008687907853269984665640564039457584007913129639872 2025-04-02 01:51:11 -81 -81 -81 115792089237316195423570985008687907853269984665640564039457584007913129639855 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 115792089237316195423570985008687907853269984665640564039457584007913129639935 2025-04-02 01:51:11 -4 -4 -4 115792089237316195423570985008687907853269984665640564039457584007913129639932 2025-04-02 01:51:11 -9 -9 -9 115792089237316195423570985008687907853269984665640564039457584007913129639927 2025-04-02 01:51:11 -16 -16 -16 115792089237316195423570985008687907853269984665640564039457584007913129639920 2025-04-02 01:51:11 -25 -25 -25 115792089237316195423570985008687907853269984665640564039457584007913129639911 2025-04-02 01:51:11 -36 -36 -36 115792089237316195423570985008687907853269984665640564039457584007913129639900 2025-04-02 01:51:11 -49 -49 -49 115792089237316195423570985008687907853269984665640564039457584007913129639887 2025-04-02 01:51:11 -64 -64 -64 115792089237316195423570985008687907853269984665640564039457584007913129639872 2025-04-02 01:51:11 -81 -81 -81 115792089237316195423570985008687907853269984665640564039457584007913129639855 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 115792089237316195423570985008687907853269984665640564039457584007913129639935 2025-04-02 01:51:11 -4 -4 -4 115792089237316195423570985008687907853269984665640564039457584007913129639932 2025-04-02 01:51:11 -9 -9 -9 115792089237316195423570985008687907853269984665640564039457584007913129639927 2025-04-02 01:51:11 -16 -16 -16 115792089237316195423570985008687907853269984665640564039457584007913129639920 2025-04-02 01:51:11 -25 -25 -25 115792089237316195423570985008687907853269984665640564039457584007913129639911 2025-04-02 01:51:11 -36 -36 -36 115792089237316195423570985008687907853269984665640564039457584007913129639900 2025-04-02 01:51:11 -49 -49 -49 115792089237316195423570985008687907853269984665640564039457584007913129639887 2025-04-02 01:51:11 -64 -64 -64 115792089237316195423570985008687907853269984665640564039457584007913129639872 2025-04-02 01:51:11 -81 -81 -81 115792089237316195423570985008687907853269984665640564039457584007913129639855 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 -1 -1 -1 115792089237316195423570985008687907853269984665640564039457584007913129639935 2025-04-02 01:51:11 -4 -4 -4 115792089237316195423570985008687907853269984665640564039457584007913129639932 2025-04-02 01:51:11 -9 -9 -9 115792089237316195423570985008687907853269984665640564039457584007913129639927 2025-04-02 01:51:11 -16 -16 -16 115792089237316195423570985008687907853269984665640564039457584007913129639920 2025-04-02 01:51:11 -25 -25 -25 115792089237316195423570985008687907853269984665640564039457584007913129639911 2025-04-02 01:51:11 -36 -36 -36 115792089237316195423570985008687907853269984665640564039457584007913129639900 2025-04-02 01:51:11 -49 -49 -49 115792089237316195423570985008687907853269984665640564039457584007913129639887 2025-04-02 01:51:11 -64 -64 -64 115792089237316195423570985008687907853269984665640564039457584007913129639872 2025-04-02 01:51:11 -81 -81 -81 115792089237316195423570985008687907853269984665640564039457584007913129639855 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 1 0 0 0 2025-04-02 01:51:11 2 0 0 0 2025-04-02 01:51:11 3 0 0 0 2025-04-02 01:51:11 4 0 0 0 2025-04-02 01:51:11 5 0 0 0 2025-04-02 01:51:11 6 0 0 0 2025-04-02 01:51:11 7 0 0 0 2025-04-02 01:51:11 8 0 0 0 2025-04-02 01:51:11 9 0 0 0 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 -1 0 0 0 2025-04-02 01:51:11 -2 0 0 0 2025-04-02 01:51:11 -3 0 0 0 2025-04-02 01:51:11 -4 0 0 0 2025-04-02 01:51:11 -5 0 0 0 2025-04-02 01:51:11 -6 0 0 0 2025-04-02 01:51:11 -7 0 0 0 2025-04-02 01:51:11 -8 0 0 0 2025-04-02 01:51:11 -9 0 0 0 2025-04-02 01:51:11 2499500025000000 2499500025000000 2499500025000000 2499500025000000 2025-04-02 01:51:11 0 0 0 0 2025-04-02 01:51:11 2025-04-02 01:51:11 2025-04-02 01:51:11 Settings used in the test: --max_insert_threads 2 --group_by_two_level_threshold 646023 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 7457589 --max_read_buffer_size 701884 --prefer_localhost_replica 0 --max_block_size 26084 --max_joined_block_size_rows 26982 --max_threads 3 --optimize_append_index 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 98 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 13847203 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method read --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 50 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 12 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 4644002578 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 1445291521 --min_compress_block_size 2677096 --max_compress_block_size 2316795 --merge_tree_compact_parts_min_granules_to_multibuffer_read 61 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 4764855 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 0 --session_timezone Africa/Khartoum --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.23 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 0 --max_parsing_threads 10 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 0 --query_plan_join_swap_table false --output_format_native_write_json_as_string 1 --enable_vertical_final 1 2025-04-02 01:51:11 2025-04-02 01:51:11 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 18 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 26797467 --merge_max_block_size 12167 --index_granularity 64545 --min_bytes_for_wide_part 0 --marks_compress_block_size 21092 --primary_key_compress_block_size 26456 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 248277046 --compact_parts_max_granules_to_buffer 111 --compact_parts_merge_max_bytes_to_prefetch_part 8223155 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 37 --old_parts_lifetime 63 --prewarm_mark_cache 0 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 1 --use_primary_key_cache 1 --prewarm_primary_key_cache 1 2025-04-02 01:51:11 2025-04-02 01:51:11 Database: test_cp2p6lhk 2025-04-02 01:51:11 02221_parallel_replicas_bug: [ FAIL ] 43.66 sec. 2025-04-02 01:51:11 Reason: server died 32 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:24.821392 [ 3807 ] {b42a54ac-c0bd-4583-8ece-f9ba78ba1905} : Logical error: 'Replica info is not initialized'. 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:25.186716 [ 3807 ] {b42a54ac-c0bd-4583-8ece-f9ba78ba1905} : Stack trace (when copying this message, always include the lines below): 2025-04-02 01:51:11 2025-04-02 01:51:11 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x00000000456d53c9 2025-04-02 01:51:11 1. ./build_docker/./src/Common/Exception.cpp:105: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000206d2853 2025-04-02 01:51:11 2. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x00000000088cd1d5 2025-04-02 01:51:11 3. DB::Exception::Exception<>(int, FormatStringHelperImpl<>) @ 0x00000000088f4804 2025-04-02 01:51:11 4. ./build_docker/./src/QueryPipeline/RemoteQueryExecutor.cpp:727: DB::RemoteQueryExecutor::processReadTaskRequest() @ 0x0000000034b283cd 2025-04-02 01:51:11 5. ./build_docker/./src/QueryPipeline/RemoteQueryExecutor.cpp:623: DB::RemoteQueryExecutor::processPacket(DB::Packet) @ 0x0000000034b21488 2025-04-02 01:51:11 6. ./build_docker/./src/QueryPipeline/RemoteQueryExecutor.cpp:562: DB::RemoteQueryExecutor::readAsync() @ 0x0000000034b25dc3 2025-04-02 01:51:11 7. ./build_docker/./src/Processors/Sources/RemoteSource.cpp:182: DB::RemoteSource::tryGenerate() @ 0x0000000040415925 2025-04-02 01:51:11 8. ./build_docker/./src/Processors/ISource.cpp:108: DB::ISource::work() @ 0x000000003f6e8571 2025-04-02 01:51:11 9. ./build_docker/./src/Processors/Sources/RemoteSource.cpp:134: DB::RemoteSource::work() @ 0x0000000040414fb0 2025-04-02 01:51:11 10. ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:49: DB::ExecutionThreadContext::executeTask() @ 0x000000003f7538b1 2025-04-02 01:51:11 11. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:290: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x000000003f71eb14 2025-04-02 01:51:11 12. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:256: DB::PipelineExecutor::executeImpl(unsigned long, bool) @ 0x000000003f71c8c3 2025-04-02 01:51:11 13. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:127: DB::PipelineExecutor::execute(unsigned long, bool) @ 0x000000003f71c2f5 2025-04-02 01:51:11 14. ./build_docker/./src/Processors/Executors/CompletedPipelineExecutor.cpp:49: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl(DB::CompletedPipelineExecutor::execute()::$_0&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000003f719de5 2025-04-02 01:51:11 15. ./contrib/llvm-project/libcxx/include/__functional/function.h:848: ? @ 0x00000000209762ca 2025-04-02 01:51:11 16. ./contrib/llvm-project/libcxx/include/__functional/invoke.h:359: ? @ 0x0000000020988a64 2025-04-02 01:51:11 17. ? @ 0x00007f583d9b1ac3 2025-04-02 01:51:11 18. ? @ 0x00007f583da43850 2025-04-02 01:51:11 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:25.190646 [ 17965 ] BaseDaemon: ######################################## 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:25.191602 [ 17965 ] BaseDaemon: (version 24.12.2.20221.altinityantalya (altinity build), build id: E3EBE392F6E30F869D3C8A7C787AA68127B123A4, git hash: 82252d159dc02cab0f366aaa5691adc1545dd11d) (from thread 3807) (query_id: b42a54ac-c0bd-4583-8ece-f9ba78ba1905) (query: INSERT INTO distributed_01099_b SELECT * FROM urlCluster('test_cluster_two_shards', 'http://localhost:8123/?query=select+{1,2,3}+format+TSV', 'TSV', 's String');) Received signal Aborted (6) 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:25.192305 [ 17965 ] BaseDaemon: 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:25.192747 [ 17965 ] BaseDaemon: Stack trace: 0x00005636c1d40a5e 0x00005636c273c1b7 0x00005636a9e66bae 0x00007f583d95f520 0x00007f583d9b39fd 0x00007f583d95f476 0x00007f583d9457f3 0x00005636c1c9248b 0x00005636c1c93e61 0x00005636a9e8e1d5 0x00005636a9eb5804 0x00005636d60e93cd 0x00005636d60e2488 0x00005636d60e6dc3 0x00005636e19d6925 0x00005636e0ca9571 0x00005636e19d5fb0 0x00005636e0d148b1 0x00005636e0cdfb14 0x00005636e0cdd8c3 0x00005636e0cdd2f5 0x00005636e0cdade5 0x00005636c1f372ca 0x00005636c1f49a64 0x00007f583d9b1ac3 0x00007f583da43850 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:25.492846 [ 17965 ] BaseDaemon: 0.0. inlined from ./build_docker/./src/Common/StackTrace.cpp:381: StackTrace::tryCapture() 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:25.493440 [ 17965 ] BaseDaemon: 0. ./build_docker/./src/Common/StackTrace.cpp:350: StackTrace::StackTrace(ucontext_t const&) @ 0x000000002077fa5e 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:25.925555 [ 17965 ] BaseDaemon: 1. ./build_docker/./src/Common/SignalHandlers.cpp:102: signalHandler(int, siginfo_t*, void*) @ 0x000000002117b1b7 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:28.995374 [ 17965 ] BaseDaemon: 2. SignalAction(int, void*, void*) @ 0x00000000088a5bae 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:28.995597 [ 17965 ] BaseDaemon: 3. ? @ 0x00007f583d95f520 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:28.995706 [ 17965 ] BaseDaemon: 4. ? @ 0x00007f583d9b39fd 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:28.995812 [ 17965 ] BaseDaemon: 5. ? @ 0x00007f583d95f476 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:28.995908 [ 17965 ] BaseDaemon: 6. ? @ 0x00007f583d9457f3 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:29.565260 [ 17965 ] BaseDaemon: 7. ./build_docker/./src/Common/Exception.cpp:48: DB::abortOnFailedAssertion(String const&, void* const*, unsigned long, unsigned long) @ 0x00000000206d148b 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:30.124129 [ 17965 ] BaseDaemon: 8.0. inlined from ./build_docker/./src/Common/Exception.cpp:70: DB::handle_error_code(String const&, int, bool, std::vector> const&) 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:30.124348 [ 17965 ] BaseDaemon: 8. ./build_docker/./src/Common/Exception.cpp:111: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000206d2e61 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:30.411014 [ 17965 ] BaseDaemon: 9. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x00000000088cd1d5 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:30.696613 [ 17965 ] BaseDaemon: 10. DB::Exception::Exception<>(int, FormatStringHelperImpl<>) @ 0x00000000088f4804 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:32.146265 [ 17965 ] BaseDaemon: 11. ./build_docker/./src/QueryPipeline/RemoteQueryExecutor.cpp:727: DB::RemoteQueryExecutor::processReadTaskRequest() @ 0x0000000034b283cd 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:33.505942 [ 17965 ] BaseDaemon: 12. ./build_docker/./src/QueryPipeline/RemoteQueryExecutor.cpp:623: DB::RemoteQueryExecutor::processPacket(DB::Packet) @ 0x0000000034b21488 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:34.855341 [ 17965 ] BaseDaemon: 13. ./build_docker/./src/QueryPipeline/RemoteQueryExecutor.cpp:562: DB::RemoteQueryExecutor::readAsync() @ 0x0000000034b25dc3 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:35.184755 [ 17965 ] BaseDaemon: 14. ./build_docker/./src/Processors/Sources/RemoteSource.cpp:182: DB::RemoteSource::tryGenerate() @ 0x0000000040415925 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:35.437885 [ 17965 ] BaseDaemon: 15. ./build_docker/./src/Processors/ISource.cpp:108: DB::ISource::work() @ 0x000000003f6e8571 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:35.728878 [ 17965 ] BaseDaemon: 16. ./build_docker/./src/Processors/Sources/RemoteSource.cpp:134: DB::RemoteSource::work() @ 0x0000000040414fb0 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:35.861080 [ 17965 ] BaseDaemon: 17.0. inlined from ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:49: DB::executeJob(DB::ExecutingGraph::Node*, DB::ReadProgressCallback*) 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:35.861263 [ 17965 ] BaseDaemon: 17. ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:98: DB::ExecutionThreadContext::executeTask() @ 0x000000003f7538b1 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:36.201114 [ 17965 ] BaseDaemon: 18. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:290: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x000000003f71eb14 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:36.531390 [ 17965 ] BaseDaemon: 19.0. inlined from ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:256: DB::PipelineExecutor::executeSingleThread(unsigned long) 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:36.531561 [ 17965 ] BaseDaemon: 19. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:442: DB::PipelineExecutor::executeImpl(unsigned long, bool) @ 0x000000003f71c8c3 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:36.868497 [ 17965 ] BaseDaemon: 20. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:127: DB::PipelineExecutor::execute(unsigned long, bool) @ 0x000000003f71c2f5 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.034529 [ 17965 ] BaseDaemon: 21.0. inlined from ./build_docker/./src/Processors/Executors/CompletedPipelineExecutor.cpp:49: DB::threadFunction(DB::CompletedPipelineExecutor::Data&, std::shared_ptr, unsigned long, bool) 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.034674 [ 17965 ] BaseDaemon: 21.1. inlined from ./build_docker/./src/Processors/Executors/CompletedPipelineExecutor.cpp:89: operator() 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.034757 [ 17965 ] BaseDaemon: 21.2. inlined from ./contrib/llvm-project/libcxx/include/__functional/invoke.h:394: ? 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.034898 [ 17965 ] BaseDaemon: 21.3. inlined from ./contrib/llvm-project/libcxx/include/tuple:1789: _ZNSt3__118__apply_tuple_implB6v15007IRZN2DB25CompletedPipelineExecutor7executeEvE3$_0RNS_5tupleIJEEETpTnmJEEEDcOT_OT0_NS_15__tuple_indicesIJXspT1_EEEE 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.035027 [ 17965 ] BaseDaemon: 21.4. inlined from ./contrib/llvm-project/libcxx/include/tuple:1798: decltype(auto) std::apply[abi:v15007]&>(DB::CompletedPipelineExecutor::execute()::$_0&, std::tuple<>&) 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.035165 [ 17965 ] BaseDaemon: 21.5. inlined from ./src/Common/ThreadPool.h:311: operator() 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.035254 [ 17965 ] BaseDaemon: 21.6. inlined from ./contrib/llvm-project/libcxx/include/__functional/invoke.h:394: ? 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.035345 [ 17965 ] BaseDaemon: 21.7. inlined from ./contrib/llvm-project/libcxx/include/__functional/invoke.h:479: ? 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.035436 [ 17965 ] BaseDaemon: 21.8. inlined from ./contrib/llvm-project/libcxx/include/__functional/function.h:235: ? 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.035527 [ 17965 ] BaseDaemon: 21. ./contrib/llvm-project/libcxx/include/__functional/function.h:716: ? @ 0x000000003f719de5 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.302717 [ 17965 ] BaseDaemon: 22.0. inlined from ./contrib/llvm-project/libcxx/include/__functional/function.h:848: ? 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.302922 [ 17965 ] BaseDaemon: 22.1. inlined from ./contrib/llvm-project/libcxx/include/__functional/function.h:1197: ? 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.303041 [ 17965 ] BaseDaemon: 22. ./build_docker/./src/Common/ThreadPool.cpp:785: ThreadPoolImpl::ThreadFromThreadPool::worker() @ 0x00000000209762ca 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.781462 [ 17965 ] BaseDaemon: 23.0. inlined from ./contrib/llvm-project/libcxx/include/__functional/invoke.h:359: ? 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.781796 [ 17965 ] BaseDaemon: 23.1. inlined from ./contrib/llvm-project/libcxx/include/thread:284: void std::__thread_execute[abi:v15007]>, void (ThreadPoolImpl::ThreadFromThreadPool::*)(), ThreadPoolImpl::ThreadFromThreadPool*, 2ul>(std::tuple>, void (ThreadPoolImpl::ThreadFromThreadPool::*)(), ThreadPoolImpl::ThreadFromThreadPool*>&, std::__tuple_indices<2ul>) 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.781922 [ 17965 ] BaseDaemon: 23. ./contrib/llvm-project/libcxx/include/thread:295: void* std::__thread_proxy[abi:v15007]>, void (ThreadPoolImpl::ThreadFromThreadPool::*)(), ThreadPoolImpl::ThreadFromThreadPool*>>(void*) @ 0x0000000020988a64 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.782036 [ 17965 ] BaseDaemon: 24. ? @ 0x00007f583d9b1ac3 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:37.782114 [ 17965 ] BaseDaemon: 25. ? @ 0x00007f583da43850 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:47.676940 [ 17965 ] BaseDaemon: Integrity check of the executable successfully passed (checksum: 003D0F8422331117266F6835F6AB47FF) 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:57.227592 [ 17965 ] BaseDaemon: This ClickHouse version is not official and should be upgraded to the official build. 2025-04-02 01:51:11 [421e3960cfe6] 2025.04.01 23:50:57.229184 [ 17965 ] BaseDaemon: Changed settings: min_compress_block_size = 687522, max_compress_block_size = 1478732, max_block_size = 70710, min_external_table_block_size_bytes = 0, max_joined_block_size_rows = 23622, max_insert_threads = 3, max_threads = 2, max_read_buffer_size = 967284, connect_timeout_with_failover_ms = 2000, connect_timeout_with_failover_secure_ms = 3000, idle_connection_timeout = 36000, s3_max_get_rps = 1000000, s3_max_get_burst = 2000000, s3_max_put_rps = 1000000, s3_max_put_burst = 2000000, s3_check_objects_after_upload = true, max_remote_read_network_bandwidth = 1000000000000, max_remote_write_network_bandwidth = 1000000000000, max_local_read_bandwidth = 1000000000000, max_local_write_bandwidth = 1000000000000, stream_like_engine_allow_direct_select = true, enable_multiple_prewhere_read_steps = false, replication_wait_for_inactive_replica_timeout = 30, min_count_to_compile_expression = 0, compile_sort_description = false, group_by_two_level_threshold = 266079, group_by_two_level_threshold_bytes = 46488210, distributed_aggregation_memory_efficient = false, allow_nonconst_timezone_arguments = true, parallel_distributed_insert_select = 1, input_format_parallel_parsing = false, min_chunk_bytes_for_parallel_parsing = 17684731, merge_tree_coarse_index_granularity = 5, min_bytes_to_use_direct_io = 9134778703, min_bytes_to_use_mmap_io = 8004858650, log_queries = true, insert_quorum_timeout = 60000, merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability = 0.9399999976158142, http_wait_end_of_query = true, http_response_buffer_size = 1924165, fsync_metadata = false, http_send_timeout = 60., http_receive_timeout = 60., use_index_for_in_with_subqueries_max_values = 1000000000, opentelemetry_start_trace_probability = 0.10000000149011612, max_rows_to_read = 20000000, max_bytes_to_read = 1000000000000, max_bytes_to_read_leaf = 1000000000000, max_rows_to_group_by = 10000000000, max_bytes_before_external_group_by = 0, max_rows_to_sort = 10000000000, max_bytes_to_sort = 10000000000, prefer_external_sort_block_bytes = 1, max_bytes_before_external_sort = 10737418240, max_bytes_before_remerge_sort = 2232045447, max_result_rows = 1000000000, max_result_bytes = 1000000000, max_execution_time = 600., max_execution_time_leaf = 600., max_execution_speed = 100000000000, max_execution_speed_bytes = 10000000000000, timeout_before_checking_execution_speed = 300., max_estimated_execution_time = 600., max_columns_to_read = 20000, max_temporary_columns = 20000, max_temporary_non_const_columns = 20000, max_rows_in_set = 10000000000, max_bytes_in_set = 10000000000, max_rows_in_join = 10000000000, max_bytes_in_join = 10000000000, cross_join_min_rows_to_compress = 0, cross_join_min_bytes_to_compress = 100000000, max_rows_to_transfer = 1000000000, max_bytes_to_transfer = 1000000000, max_rows_in_distinct = 10000000000, max_bytes_in_distinct = 10000000000, max_memory_usage = 5000000000, max_memory_usage_for_user = 32000000000, max_untracked_memory = 1048576, memory_profiler_step = 1048576, max_network_bandwidth = 100000000000, max_network_bytes = 1000000000000, max_network_bandwidth_for_user = 100000000000, max_network_bandwidth_for_all_users = 100000000000, max_temporary_data_on_disk_size_for_user = 100000000000, max_temporary_data_on_disk_size_for_query = 100000000000, max_backup_bandwidth = 100000000000, log_comment = '02221_parallel_replicas_bug.sh', send_logs_level = 'error', prefer_localhost_replica = false, optimize_aggregation_in_order = true, aggregation_in_order_max_block_bytes = 25006055, read_in_order_two_level_merge_threshold = 48, max_hyperscan_regexp_length = 1000000, max_hyperscan_regexp_total_length = 10000000, allow_introspection_functions = true, database_atomic_wait_for_drop_and_detach_synchronously = true, optimize_if_chain_to_multiif = true, optimize_functions_to_subcolumns = false, query_cache_max_size_in_bytes = 10000000, query_cache_max_entries = 100000, distributed_ddl_entry_format_version = 6, external_storage_max_read_rows = 10000000000, external_storage_max_read_bytes = 10000000000, local_filesystem_read_method = 'io_uring', remote_filesystem_read_method = 'read', local_filesystem_read_prefetch = true, remote_filesystem_read_prefetch = false, merge_tree_min_bytes_per_task_for_remote_reading = 8388608, merge_tree_compact_parts_min_granules_to_multibuffer_read = 110, async_insert_busy_timeout_max_ms = 5000, enable_filesystem_cache = true, enable_filesystem_cache_on_write_operations = true, filesystem_cache_segments_batch_size = 1, page_cache_inject_eviction = true, load_marks_asynchronously = true, allow_prefetched_read_pool_for_remote_filesystem = false, allow_prefetched_read_pool_for_local_filesystem = false, filesystem_prefetch_step_marks = 50, filesystem_prefetch_max_memory_usage = 67108864, filesystem_prefetches_limit = 10, max_streams_for_merge_tree_reading = 1000, optimize_sorting_by_input_stream_properties = false, insert_keeper_max_retries = 100, insert_keeper_retry_initial_backoff_ms = 1, insert_keeper_retry_max_backoff_ms = 10, insert_keeper_fault_injection_probability = 0.009999999776482582, allow_experimental_parallel_reading_from_replicas = 0, parallel_replicas_for_non_replicated_merge_tree = true, parallel_replicas_local_plan = false, session_timezone = 'Africa/Khartoum', output_format_native_write_json_as_string = true 2025-04-02 01:51:11 Error on processing query: Code: 32. DB::Exception: Attempt to read after eof: while receiving packet from localhost:9000. (ATTEMPT_TO_READ_AFTER_EOF) (version 24.12.2.20221.altinityantalya (altinity build)) 2025-04-02 01:51:11 (query: INSERT INTO distributed_01099_b SELECT * FROM urlCluster('test_cluster_two_shards', 'http://localhost:8123/?query=select+{1,2,3}+format+TSV', 'TSV', 's String');) 2025-04-02 01:51:11 , result: 2025-04-02 01:51:11 2025-04-02 01:51:11 2025-04-02 01:51:11 2025-04-02 01:51:11 stdout: 2025-04-02 01:51:11 2025-04-02 01:51:11 2025-04-02 01:51:11 Settings used in the test: --max_insert_threads 3 --group_by_two_level_threshold 266079 --group_by_two_level_threshold_bytes 46488210 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 17684731 --max_read_buffer_size 967284 --prefer_localhost_replica 0 --max_block_size 70710 --max_joined_block_size_rows 23622 --max_threads 2 --optimize_append_index 0 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 0 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 48 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 25006055 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 9134778703 --min_bytes_to_use_mmap_io 8004858650 --local_filesystem_read_method io_uring --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 1 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 5 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 0 --max_bytes_before_remerge_sort 2232045447 --min_compress_block_size 687522 --max_compress_block_size 1478732 --merge_tree_compact_parts_min_granules_to_multibuffer_read 110 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 1924165 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone Africa/Khartoum --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.94 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 0 --max_parsing_threads 0 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 0 --query_plan_join_swap_table auto --output_format_native_write_json_as_string 1 --enable_vertical_final 1 2025-04-02 01:51:11 2025-04-02 01:51:11 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 1223568508 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 20921482 --merge_max_block_size 442 --index_granularity 27635 --min_bytes_for_wide_part 421092512 --marks_compress_block_size 43556 --primary_key_compress_block_size 45108 --replace_long_file_name_to_hash 0 --max_file_name_length 82 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 456393955 --compact_parts_max_granules_to_buffer 110 --compact_parts_merge_max_bytes_to_prefetch_part 12985887 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 50 --old_parts_lifetime 480 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 0 --use_primary_key_cache 0 --prewarm_primary_key_cache 0 2025-04-02 01:51:11 2025-04-02 01:51:11 Database: test_12ids2lr 2025-04-02 01:51:11 03094_one_thousand_joins: [ FAIL ] 32.33 sec. 2025-04-02 01:51:11 Reason: return code: 32 2025-04-02 01:51:11 Error on processing query: Code: 32. DB::Exception: Attempt to read after eof: while receiving packet from localhost:9000. (ATTEMPT_TO_READ_AFTER_EOF) (version 24.12.2.20221.altinityantalya (altinity build)) 2025-04-02 01:51:11 (query: -- Bug 33446, marked as 'long' because it still runs around 10 sec 2025-04-02 01:51:11 SELECT * FROM (SELECT 1 AS x) t1 JOIN (SELECT 1 AS x) t2 ON t1.x = t2.x JOIN (SELECT 1 AS x) t3 ON t1.x = t3.x JOIN (SELECT 1 AS x) t4 ON t1.x = t4.x JOIN (SELECT 1 AS x) t5 ON t1.x = t5.x JOIN (SELECT 1 AS x) t6 ON t1.x = t6.x JOIN (SELECT 1 AS x) t7 ON t1.x = t7.x JOIN (SELECT 1 AS x) t8 ON t1.x = t8.x JOIN (SELECT 1 AS x) t9 ON t1.x = t9.x JOIN (SELECT 1 AS x) t10 ON t1.x = t10.x JOIN (SELECT 1 AS x) t11 ON t1.x = t11.x JOIN (SELECT 1 AS x) t12 ON t1.x = t12.x JOIN (SELECT 1 AS x) t13 ON t1.x = t13.x JOIN (SELECT 1 AS x) t14 ON t1.x = t14.x JOIN (SELECT 1 AS x) t15 ON t1.x = t15.x JOIN (SELECT 1 AS x) t16 ON t1.x = t16.x JOIN (SELECT 1 AS x) t17 ON t1.x = t17.x JOIN (SELECT 1 AS x) t18 ON t1.x = t18.x JOIN (SELECT 1 AS x) t19 ON t1.x = t19.x JOIN (SELECT 1 AS x) t20 ON t1.x = t20.x JOIN (SELECT 1 AS x) t21 ON t1.x = t21.x JOIN (SELECT 1 AS x) t22 ON t1.x = t22.x JOIN (SELECT 1 AS x) t23 ON t1.x = t23.x JOIN (SELECT 1 AS x) t24 ON t1.x = t24.x JOIN (SELECT 1 AS x) t25 ON t1.x = t25.x JOIN (SELECT 1 AS x) t26 ON t1.x = t26.x JOIN (SELECT 1 AS x) t27 ON t1.x = t27.x JOIN (SELECT 1 AS x) t28 ON t1.x = t28.x JOIN (SELECT 1 AS x) t29 ON t1.x = t29.x JOIN (SELECT 1 AS x) t30 ON t1.x = t30.x JOIN (SELECT 1 AS x) t31 ON t1.x = t31.x JOIN (SELECT 1 AS x) t32 ON t1.x = t32.x JOIN (SELECT 1 AS x) t33 ON t1.x = t33.x JOIN (SELECT 1 AS x) t34 ON t1.x = t34.x JOIN (SELECT 1 AS x) t35 ON t1.x = t35.x JOIN (SELECT 1 AS x) t36 ON t1.x = t36.x JOIN (SELECT 1 AS x) t37 ON t1.x = t37.x JOIN (SELECT 1 AS x) t38 ON t1.x = t38.x JOIN (SELECT 1 AS x) t39 ON t1.x = t39.x JOIN (SELECT 1 AS x) t40 ON t1.x = t40.x JOIN (SELECT 1 AS x) t41 ON t1.x = t41.x JOIN (SELECT 1 AS x) t42 ON t1.x = t42.x JOIN (SELECT 1 AS x) t43 ON t1.x = t43.x JOIN (SELECT 1 AS x) t44 ON t1.x = t44.x JOIN (SELECT 1 AS x) t45 ON t1.x = t45.x JOIN (SELECT 1 AS x) t46 ON t1.x = t46.x JOIN (SELECT 1 AS x) t47 ON t1.x = t47.x JOIN (SELECT 1 AS x) t48 ON t1.x = t48.x JOIN (SELECT 1 AS x) t49 ON t1.x = t49.x JOIN (SELECT 1 AS x) t50 ON t1.x = t50.x JOIN (SELECT 1 AS x) t51 ON t1.x = t51.x JOIN (SELECT 1 AS x) t52 ON t1.x = t52.x JOIN (SELECT 1 AS x) t53 ON t1.x = t53.x JOIN (SELECT 1 AS x) t54 ON t1.x = t54.x JOIN (SELECT 1 AS x) t55 ON t1.x = t55.x JOIN (SELECT 1 AS x) t56 ON t1.x = t56.x JOIN (SELECT 1 AS x) t57 ON t1.x = t57.x JOIN (SELECT 1 AS x) t58 ON t1.x = t58.x JOIN (SELECT 1 AS x) t59 ON t1.x = t59.x JOIN (SELECT 1 AS x) t60 ON t1.x = t60.x JOIN (SELECT 1 AS x) t61 ON t1.x = t61.x JOIN (SELECT 1 AS x) t62 ON t1.x = t62.x JOIN (SELECT 1 AS x) t63 ON t1.x = t63.x JOIN (SELECT 1 AS x) t64 ON t1.x = t64.x JOIN (SELECT 1 AS x) t65 ON t1.x = t65.x JOIN (SELECT 1 AS x) t66 ON t1.x = t66.x JOIN (SELECT 1 AS x) t67 ON t1.x = t67.x JOIN (SELECT 1 AS x) t68 ON t1.x = t68.x JOIN (SELECT 1 AS x) t69 ON t1.x = t69.x JOIN (SELECT 1 AS x) t70 ON t1.x = t70.x JOIN (SELECT 1 AS x) t71 ON t1.x = t71.x JOIN (SELECT 1 AS x) t72 ON t1.x = t72.x JOIN (SELECT 1 AS x) t73 ON t1.x = t73.x JOIN (SELECT 1 AS x) t74 ON t1.x = t74.x JOIN (SELECT 1 AS x) t75 ON t1.x = t75.x JOIN (SELECT 1 AS x) t76 ON t1.x = t76.x JOIN (SELECT 1 AS x) t77 ON t1.x = t77.x JOIN (SELECT 1 AS x) t78 ON t1.x = t78.x JOIN (SELECT 1 AS x) t79 ON t1.x = t79.x JOIN (SELECT 1 AS x) t80 ON t1.x = t80.x JOIN (SELECT 1 AS x) t81 ON t1.x = t81.x JOIN (SELECT 1 AS x) t82 ON t1.x = t82.x JOIN (SELECT 1 AS x) t83 ON t1.x = t83.x JOIN (SELECT 1 AS x) t84 ON t1.x = t84.x JOIN (SELECT 1 AS x) t85 ON t1.x = t85.x JOIN (SELECT 1 AS x) t86 ON t1.x = t86.x JOIN (SELECT 1 AS x) t87 ON t1.x = t87.x JOIN (SELECT 1 AS x) t88 ON t1.x = t88.x JOIN (SELECT 1 AS x) t89 ON t1.x = t89.x JOIN (SELECT 1 AS x) t90 ON t1.x = t90.x JOIN (SELECT 1 AS x) t91 ON t1.x = t91.x JOIN (SELECT 1 AS x) t92 ON t1.x = t92.x JOIN (SELECT 1 AS x) t93 ON t1.x = t93.x JOIN (SELECT 1 AS x) t94 ON t1.x = t94.x JOIN (SELECT 1 AS x) t95 ON t1.x = t95.x JOIN (SELECT 1 AS x) t96 ON t1.x = t96.x JOIN (SELECT 1 AS x) t97 ON t1.x = t97.x JOIN (SELECT 1 AS x) t98 ON t1.x = t98.x JOIN (SELECT 1 AS x) t99 ON t1.x = t99.x JOIN (SELECT 1 AS x) t100 ON t1.x = t100.x JOIN (SELECT 1 AS x) t101 ON t1.x = t101.x JOIN (SELECT 1 AS x) t102 ON t1.x = t102.x JOIN (SELECT 1 AS x) t103 ON t1.x = t103.x JOIN (SELECT 1 AS x) t104 ON t1.x = t104.x JOIN (SELECT 1 AS x) t105 ON t1.x = t105.x JOIN (SELECT 1 AS x) t106 ON t1.x = t106.x JOIN (SELECT 1 AS x) t107 ON t1.x = t107.x JOIN (SELECT 1 AS x) t108 ON t1.x = t108.x JOIN (SELECT 1 AS x) t109 ON t1.x = t109.x JOIN (SELECT 1 AS x) t110 ON t1.x = t110.x JOIN (SELECT 1 AS x) t111 ON t1.x = t111.x JOIN (SELECT 1 AS x) t112 ON t1.x = t112.x JOIN (SELECT 1 AS x) t113 ON t1.x = t113.x JOIN (SELECT 1 AS x) t114 ON t1.x = t114.x JOIN (SELECT 1 AS x) t115 ON t1.x = t115.x JOIN (SELECT 1 AS x) t116 ON t1.x = t116.x JOIN (SELECT 1 AS x) t117 ON t1.x = t117.x JOIN (SELECT 1 AS x) t118 ON t1.x = t118.x JOIN (SELECT 1 AS x) t119 ON t1.x = t119.x JOIN (SELECT 1 AS x) t120 ON t1.x = t120.x JOIN (SELECT 1 AS x) t121 ON t1.x = t121.x JOIN (SELECT 1 AS x) t122 ON t1.x = t122.x JOIN (SELECT 1 AS x) t123 ON t1.x = t123.x JOIN (SELECT 1 AS x) t124 ON t1.x = t124.x JOIN (SELECT 1 AS x) t125 ON t1.x = t125.x JOIN (SELECT 1 AS x) t126 ON t1.x = t126.x JOIN (SELECT 1 AS x) t127 ON t1.x = t127.x JOIN (SELECT 1 AS x) t128 ON t1.x = t128.x JOIN (SELECT 1 AS x) t129 ON t1.x = t129.x JOIN (SELECT 1 AS x) t130 ON t1.x = t130.x JOIN (SELECT 1 AS x) t131 ON t1.x = t131.x JOIN (SELECT 1 AS x) t132 ON t1.x = t132.x JOIN (SELECT 1 AS x) t133 ON t1.x = t133.x JOIN (SELECT 1 AS x) t134 ON t1.x = t134.x JOIN (SELECT 1 AS x) t135 ON t1.x = t135.x JOIN (SELECT 1 AS x) t136 ON t1.x = t136.x JOIN (SELECT 1 AS x) t137 ON t1.x = t137.x JOIN (SELECT 1 AS x) t138 ON t1.x = t138.x JOIN (SELECT 1 AS x) t139 ON t1.x = t139.x JOIN (SELECT 1 AS x) t140 ON t1.x = t140.x JOIN (SELECT 1 AS x) t141 ON t1.x = t141.x JOIN (SELECT 1 AS x) t142 ON t1.x = t142.x JOIN (SELECT 1 AS x) t143 ON t1.x = t143.x JOIN (SELECT 1 AS x) t144 ON t1.x = t144.x JOIN (SELECT 1 AS x) t145 ON t1.x = t145.x JOIN (SELECT 1 AS x) t146 ON t1.x = t146.x JOIN (SELECT 1 AS x) t147 ON t1.x = t147.x JOIN (SELECT 1 AS x) t148 ON t1.x = t148.x JOIN (SELECT 1 AS x) t149 ON t1.x = t149.x JOIN (SELECT 1 AS x) t150 ON t1.x = t150.x JOIN (SELECT 1 AS x) t151 ON t1.x = t151.x JOIN (SELECT 1 AS x) t152 ON t1.x = t152.x JOIN (SELECT 1 AS x) t153 ON t1.x = t153.x JOIN (SELECT 1 AS x) t154 ON t1.x = t154.x JOIN (SELECT 1 AS x) t155 ON t1.x = t155.x JOIN (SELECT 1 AS x) t156 ON t1.x = t156.x JOIN (SELECT 1 AS x) t157 ON t1.x = t157.x JOIN (SELECT 1 AS x) t158 ON t1.x = t158.x JOIN (SELECT 1 AS x) t159 ON t1.x = t159.x JOIN (SELECT 1 AS x) t160 ON t1.x = t160.x JOIN (SELECT 1 AS x) t161 ON t1.x = t161.x JOIN (SELECT 1 AS x) t162 ON t1.x = t162.x JOIN (SELECT 1 AS x) t163 ON t1.x = t163.x JOIN (SELECT 1 AS x) t164 ON t1.x = t164.x JOIN (SELECT 1 AS x) t165 ON t1.x = t165.x JOIN (SELECT 1 AS x) t166 ON t1.x = t166.x JOIN (SELECT 1 AS x) t167 ON t1.x = t167.x JOIN (SELECT 1 AS x) t168 ON t1.x = t168.x JOIN (SELECT 1 AS x) t169 ON t1.x = t169.x JOIN (SELECT 1 AS x) t170 ON t1.x = t170.x JOIN (SELECT 1 AS x) t171 ON t1.x = t171.x JOIN (SELECT 1 AS x) t172 ON t1.x = t172.x JOIN (SELECT 1 AS x) t173 ON t1.x = t173.x JOIN (SELECT 1 AS x) t174 ON t1.x = t174.x JOIN (SELECT 1 AS x) t175 ON t1.x = t175.x JOIN (SELECT 1 AS x) t176 ON t1.x = t176.x JOIN (SELECT 1 AS x) t177 ON t1.x = t177.x JOIN (SELECT 1 AS x) t178 ON t1.x = t178.x JOIN (SELECT 1 AS x) t179 ON t1.x = t179.x JOIN (SELECT 1 AS x) t180 ON t1.x = t180.x JOIN (SELECT 1 AS x) t181 ON t1.x = t181.x JOIN (SELECT 1 AS x) t182 ON t1.x = t182.x JOIN (SELECT 1 AS x) t183 ON t1.x = t183.x JOIN (SELECT 1 AS x) t184 ON t1.x = t184.x JOIN (SELECT 1 AS x) t185 ON t1.x = t185.x JOIN (SELECT 1 AS x) t186 ON t1.x = t186.x JOIN (SELECT 1 AS x) t187 ON t1.x = t187.x JOIN (SELECT 1 AS x) t188 ON t1.x = t188.x JOIN (SELECT 1 AS x) t189 ON t1.x = t189.x JOIN (SELECT 1 AS x) t190 ON t1.x = t190.x JOIN (SELECT 1 AS x) t191 ON t1.x = t191.x JOIN (SELECT 1 AS x) t192 ON t1.x = t192.x JOIN (SELECT 1 AS x) t193 ON t1.x = t193.x JOIN (SELECT 1 AS x) t194 ON t1.x = t194.x JOIN (SELECT 1 AS x) t195 ON t1.x = t195.x JOIN (SELECT 1 AS x) t196 ON t1.x = t196.x JOIN (SELECT 1 AS x) t197 ON t1.x = t197.x JOIN (SELECT 1 AS x) t198 ON t1.x = t198.x JOIN (SELECT 1 AS x) t199 ON t1.x = t199.x JOIN (SELECT 1 AS x) t200 ON t1.x = t200.x JOIN (SELECT 1 AS x) t201 ON t1.x = t201.x JOIN (SELECT 1 AS x) t202 ON t1.x = t202.x JOIN (SELECT 1 AS x) t203 ON t1.x = t203.x JOIN (SELECT 1 AS x) t204 ON t1.x = t204.x JOIN (SELECT 1 AS x) t205 ON t1.x = t205.x JOIN (SELECT 1 AS x) t206 ON t1.x = t206.x JOIN (SELECT 1 AS x) t207 ON t1.x = t207.x JOIN (SELECT 1 AS x) t208 ON t1.x = t208.x JOIN (SELECT 1 AS x) t209 ON t1.x = t209.x JOIN (SELECT 1 AS x) t210 ON t1.x = t210.x JOIN (SELECT 1 AS x) t211 ON t1.x = t211.x JOIN (SELECT 1 AS x) t212 ON t1.x = t212.x JOIN (SELECT 1 AS x) t213 ON t1.x = t213.x JOIN (SELECT 1 AS x) t214 ON t1.x = t214.x JOIN (SELECT 1 AS x) t215 ON t1.x = t215.x JOIN (SELECT 1 AS x) t216 ON t1.x = t216.x JOIN (SELECT 1 AS x) t217 ON t1.x = t217.x JOIN (SELECT 1 AS x) t218 ON t1.x = t218.x JOIN (SELECT 1 AS x) t219 ON t1.x = t219.x JOIN (SELECT 1 AS x) t220 ON t1.x = t220.x JOIN (SELECT 1 AS x) t221 ON t1.x = t221.x JOIN (SELECT 1 AS x) t222 ON t1.x = t222.x JOIN (SELECT 1 AS x) t223 ON t1.x = t223.x JOIN (SELECT 1 AS x) t224 ON t1.x = t224.x JOIN (SELECT 1 AS x) t225 ON t1.x = t225.x JOIN (SELECT 1 AS x) t226 ON t1.x = t226.x JOIN (SELECT 1 AS x) t227 ON t1.x = t227.x JOIN (SELECT 1 AS x) t228 ON t1.x = t228.x JOIN (SELECT 1 AS x) t229 ON t1.x = t229.x JOIN (SELECT 1 AS x) t230 ON t1.x = t230.x JOIN (SELECT 1 AS x) t231 ON t1.x = t231.x JOIN (SELECT 1 AS x) t232 ON t1.x = t232.x JOIN (SELECT 1 AS x) t233 ON t1.x = t233.x JOIN (SELECT 1 AS x) t234 ON t1.x = t234.x JOIN (SELECT 1 AS x) t235 ON t1.x = t235.x JOIN (SELECT 1 AS x) t236 ON t1.x = t236.x JOIN (SELECT 1 AS x) t237 ON t1.x = t237.x JOIN (SELECT 1 AS x) t238 ON t1.x = t238.x JOIN (SELECT 1 AS x) t239 ON t1.x = t239.x JOIN (SELECT 1 AS x) t240 ON t1.x = t240.x JOIN (SELECT 1 AS x) t241 ON t1.x = t241.x JOIN (SELECT 1 AS x) t242 ON t1.x = t242.x JOIN (SELECT 1 AS x) t243 ON t1.x = t243.x JOIN (SELECT 1 AS x) t244 ON t1.x = t244.x JOIN (SELECT 1 AS x) t245 ON t1.x = t245.x JOIN (SELECT 1 AS x) t246 ON t1.x = t246.x JOIN (SELECT 1 AS x) t247 ON t1.x = t247.x JOIN (SELECT 1 AS x) t248 ON t1.x = t248.x JOIN (SELECT 1 AS x) t249 ON t1.x = t249.x JOIN (SELECT 1 AS x) t250 ON t1.x = t250.x JOIN (SELECT 1 AS x) t251 ON t1.x = t251.x JOIN (SELECT 1 AS x) t252 ON t1.x = t252.x JOIN (SELECT 1 AS x) t253 ON t1.x = t253.x JOIN (SELECT 1 AS x) t254 ON t1.x = t254.x JOIN (SELECT 1 AS x) t255 ON t1.x = t255.x JOIN (SELECT 1 AS x) t256 ON t1.x = t256.x JOIN (SELECT 1 AS x) t257 ON t1.x = t257.x JOIN (SELECT 1 AS x) t258 ON t1.x = t258.x JOIN (SELECT 1 AS x) t259 ON t1.x = t259.x JOIN (SELECT 1 AS x) t260 ON t1.x = t260.x JOIN (SELECT 1 AS x) t261 ON t1.x = t261.x JOIN (SELECT 1 AS x) t262 ON t1.x = t262.x JOIN (SELECT 1 AS x) t263 ON t1.x = t263.x JOIN (SELECT 1 AS x) t264 ON t1.x = t264.x JOIN (SELECT 1 AS x) t265 ON t1.x = t265.x JOIN (SELECT 1 AS x) t266 ON t1.x = t266.x JOIN (SELECT 1 AS x) t267 ON t1.x = t267.x JOIN (SELECT 1 AS x) t268 ON t1.x = t268.x JOIN (SELECT 1 AS x) t269 ON t1.x = t269.x JOIN (SELECT 1 AS x) t270 ON t1.x = t270.x JOIN (SELECT 1 AS x) t271 ON t1.x = t271.x JOIN (SELECT 1 AS x) t272 ON t1.x = t272.x JOIN (SELECT 1 AS x) t273 ON t1.x = t273.x JOIN (SELECT 1 AS x) t274 ON t1.x = t274.x JOIN (SELECT 1 AS x) t275 ON t1.x = t275.x JOIN (SELECT 1 AS x) t276 ON t1.x = t276.x JOIN (SELECT 1 AS x) t277 ON t1.x = t277.x JOIN (SELECT 1 AS x) t278 ON t1.x = t278.x JOIN (SELECT 1 AS x) t279 ON t1.x = t279.x JOIN (SELECT 1 AS x) t280 ON t1.x = t280.x JOIN (SELECT 1 AS x) t281 ON t1.x = t281.x JOIN (SELECT 1 AS x) t282 ON t1.x = t282.x JOIN (SELECT 1 AS x) t283 ON t1.x = t283.x JOIN (SELECT 1 AS x) t284 ON t1.x = t284.x JOIN (SELECT 1 AS x) t285 ON t1.x = t285.x JOIN (SELECT 1 AS x) t286 ON t1.x = t286.x JOIN (SELECT 1 AS x) t287 ON t1.x = t287.x JOIN (SELECT 1 AS x) t288 ON t1.x = t288.x JOIN (SELECT 1 AS x) t289 ON t1.x = t289.x JOIN (SELECT 1 AS x) t290 ON t1.x = t290.x JOIN (SELECT 1 AS x) t291 ON t1.x = t291.x JOIN (SELECT 1 AS x) t292 ON t1.x = t292.x JOIN (SELECT 1 AS x) t293 ON t1.x = t293.x JOIN (SELECT 1 AS x) t294 ON t1.x = t294.x JOIN (SELECT 1 AS x) t295 ON t1.x = t295.x JOIN (SELECT 1 AS x) t296 ON t1.x = t296.x JOIN (SELECT 1 AS x) t297 ON t1.x = t297.x JOIN (SELECT 1 AS x) t298 ON t1.x = t298.x JOIN (SELECT 1 AS x) t299 ON t1.x = t299.x JOIN (SELECT 1 AS x) t300 ON t1.x = t300.x JOIN (SELECT 1 AS x) t301 ON t1.x = t301.x JOIN (SELECT 1 AS x) t302 ON t1.x = t302.x JOIN (SELECT 1 AS x) t303 ON t1.x = t303.x JOIN (SELECT 1 AS x) t304 ON t1.x = t304.x JOIN (SELECT 1 AS x) t305 ON t1.x = t305.x JOIN (SELECT 1 AS x) t306 ON t1.x = t306.x JOIN (SELECT 1 AS x) t307 ON t1.x = t307.x JOIN (SELECT 1 AS x) t308 ON t1.x = t308.x JOIN (SELECT 1 AS x) t309 ON t1.x = t309.x JOIN (SELECT 1 AS x) t310 ON t1.x = t310.x JOIN (SELECT 1 AS x) t311 ON t1.x = t311.x JOIN (SELECT 1 AS x) t312 ON t1.x = t312.x JOIN (SELECT 1 AS x) t313 ON t1.x = t313.x JOIN (SELECT 1 AS x) t314 ON t1.x = t314.x JOIN (SELECT 1 AS x) t315 ON t1.x = t315.x JOIN (SELECT 1 AS x) t316 ON t1.x = t316.x JOIN (SELECT 1 AS x) t317 ON t1.x = t317.x JOIN (SELECT 1 AS x) t318 ON t1.x = t318.x JOIN (SELECT 1 AS x) t319 ON t1.x = t319.x JOIN (SELECT 1 AS x) t320 ON t1.x = t320.x JOIN (SELECT 1 AS x) t321 ON t1.x = t321.x JOIN (SELECT 1 AS x) t322 ON t1.x = t322.x JOIN (SELECT 1 AS x) t323 ON t1.x = t323.x JOIN (SELECT 1 AS x) t324 ON t1.x = t324.x JOIN (SELECT 1 AS x) t325 ON t1.x = t325.x JOIN (SELECT 1 AS x) t326 ON t1.x = t326.x JOIN (SELECT 1 AS x) t327 ON t1.x = t327.x JOIN (SELECT 1 AS x) t328 ON t1.x = t328.x JOIN (SELECT 1 AS x) t329 ON t1.x = t329.x JOIN (SELECT 1 AS x) t330 ON t1.x = t330.x JOIN (SELECT 1 AS x) t331 ON t1.x = t331.x JOIN (SELECT 1 AS x) t332 ON t1.x = t332.x JOIN (SELECT 1 AS x) t333 ON t1.x = t333.x JOIN (SELECT 1 AS x) t334 ON t1.x = t334.x JOIN (SELECT 1 AS x) t335 ON t1.x = t335.x JOIN (SELECT 1 AS x) t336 ON t1.x = t336.x JOIN (SELECT 1 AS x) t337 ON t1.x = t337.x JOIN (SELECT 1 AS x) t338 ON t1.x = t338.x JOIN (SELECT 1 AS x) t339 ON t1.x = t339.x JOIN (SELECT 1 AS x) t340 ON t1.x = t340.x JOIN (SELECT 1 AS x) t341 ON t1.x = t341.x JOIN (SELECT 1 AS x) t342 ON t1.x = t342.x JOIN (SELECT 1 AS x) t343 ON t1.x = t343.x JOIN (SELECT 1 AS x) t344 ON t1.x = t344.x JOIN (SELECT 1 AS x) t345 ON t1.x = t345.x JOIN (SELECT 1 AS x) t346 ON t1.x = t346.x JOIN (SELECT 1 AS x) t347 ON t1.x = t347.x JOIN (SELECT 1 AS x) t348 ON t1.x = t348.x JOIN (SELECT 1 AS x) t349 ON t1.x = t349.x JOIN (SELECT 1 AS x) t350 ON t1.x = t350.x JOIN (SELECT 1 AS x) t351 ON t1.x = t351.x JOIN (SELECT 1 AS x) t352 ON t1.x = t352.x JOIN (SELECT 1 AS x) t353 ON t1.x = t353.x JOIN (SELECT 1 AS x) t354 ON t1.x = t354.x JOIN (SELECT 1 AS x) t355 ON t1.x = t355.x JOIN (SELECT 1 AS x) t356 ON t1.x = t356.x JOIN (SELECT 1 AS x) t357 ON t1.x = t357.x JOIN (SELECT 1 AS x) t358 ON t1.x = t358.x JOIN (SELECT 1 AS x) t359 ON t1.x = t359.x JOIN (SELECT 1 AS x) t360 ON t1.x = t360.x JOIN (SELECT 1 AS x) t361 ON t1.x = t361.x JOIN (SELECT 1 AS x) t362 ON t1.x = t362.x JOIN (SELECT 1 AS x) t363 ON t1.x = t363.x JOIN (SELECT 1 AS x) t364 ON t1.x = t364.x JOIN (SELECT 1 AS x) t365 ON t1.x = t365.x JOIN (SELECT 1 AS x) t366 ON t1.x = t366.x JOIN (SELECT 1 AS x) t367 ON t1.x = t367.x JOIN (SELECT 1 AS x) t368 ON t1.x = t368.x JOIN (SELECT 1 AS x) t369 ON t1.x = t369.x JOIN (SELECT 1 AS x) t370 ON t1.x = t370.x JOIN (SELECT 1 AS x) t371 ON t1.x = t371.x JOIN (SELECT 1 AS x) t372 ON t1.x = t372.x JOIN (SELECT 1 AS x) t373 ON t1.x = t373.x JOIN (SELECT 1 AS x) t374 ON t1.x = t374.x JOIN (SELECT 1 AS x) t375 ON t1.x = t375.x JOIN (SELECT 1 AS x) t376 ON t1.x = t376.x JOIN (SELECT 1 AS x) t377 ON t1.x = t377.x JOIN (SELECT 1 AS x) t378 ON t1.x = t378.x JOIN (SELECT 1 AS x) t379 ON t1.x = t379.x JOIN (SELECT 1 AS x) t380 ON t1.x = t380.x JOIN (SELECT 1 AS x) t381 ON t1.x = t381.x JOIN (SELECT 1 AS x) t382 ON t1.x = t382.x JOIN (SELECT 1 AS x) t383 ON t1.x = t383.x JOIN (SELECT 1 AS x) t384 ON t1.x = t384.x JOIN (SELECT 1 AS x) t385 ON t1.x = t385.x JOIN (SELECT 1 AS x) t386 ON t1.x = t386.x JOIN (SELECT 1 AS x) t387 ON t1.x = t387.x JOIN (SELECT 1 AS x) t388 ON t1.x = t388.x JOIN (SELECT 1 AS x) t389 ON t1.x = t389.x JOIN (SELECT 1 AS x) t390 ON t1.x = t390.x JOIN (SELECT 1 AS x) t391 ON t1.x = t391.x JOIN (SELECT 1 AS x) t392 ON t1.x = t392.x JOIN (SELECT 1 AS x) t393 ON t1.x = t393.x JOIN (SELECT 1 AS x) t394 ON t1.x = t394.x JOIN (SELECT 1 AS x) t395 ON t1.x = t395.x JOIN (SELECT 1 AS x) t396 ON t1.x = t396.x JOIN (SELECT 1 AS x) t397 ON t1.x = t397.x JOIN (SELECT 1 AS x) t398 ON t1.x = t398.x JOIN (SELECT 1 AS x) t399 ON t1.x = t399.x JOIN (SELECT 1 AS x) t400 ON t1.x = t400.x JOIN (SELECT 1 AS x) t401 ON t1.x = t401.x JOIN (SELECT 1 AS x) t402 ON t1.x = t402.x JOIN (SELECT 1 AS x) t403 ON t1.x = t403.x JOIN (SELECT 1 AS x) t404 ON t1.x = t404.x JOIN (SELECT 1 AS x) t405 ON t1.x = t405.x JOIN (SELECT 1 AS x) t406 ON t1.x = t406.x JOIN (SELECT 1 AS x) t407 ON t1.x = t407.x JOIN (SELECT 1 AS x) t408 ON t1.x = t408.x JOIN (SELECT 1 AS x) t409 ON t1.x = t409.x JOIN (SELECT 1 AS x) t410 ON t1.x = t410.x JOIN (SELECT 1 AS x) t411 ON t1.x = t411.x JOIN (SELECT 1 AS x) t412 ON t1.x = t412.x JOIN (SELECT 1 AS x) t413 ON t1.x = t413.x JOIN (SELECT 1 AS x) t414 ON t1.x = t414.x JOIN (SELECT 1 AS x) t415 ON t1.x = t415.x JOIN (SELECT 1 AS x) t416 ON t1.x = t416.x JOIN (SELECT 1 AS x) t417 ON t1.x = t417.x JOIN (SELECT 1 AS x) t418 ON t1.x = t418.x JOIN (SELECT 1 AS x) t419 ON t1.x = t419.x JOIN (SELECT 1 AS x) t420 ON t1.x = t420.x JOIN (SELECT 1 AS x) t421 ON t1.x = t421.x JOIN (SELECT 1 AS x) t422 ON t1.x = t422.x JOIN (SELECT 1 AS x) t423 ON t1.x = t423.x JOIN (SELECT 1 AS x) t424 ON t1.x = t424.x JOIN (SELECT 1 AS x) t425 ON t1.x = t425.x JOIN (SELECT 1 AS x) t426 ON t1.x = t426.x JOIN (SELECT 1 AS x) t427 ON t1.x = t427.x JOIN (SELECT 1 AS x) t428 ON t1.x = t428.x JOIN (SELECT 1 AS x) t429 ON t1.x = t429.x JOIN (SELECT 1 AS x) t430 ON t1.x = t430.x JOIN (SELECT 1 AS x) t431 ON t1.x = t431.x JOIN (SELECT 1 AS x) t432 ON t1.x = t432.x JOIN (SELECT 1 AS x) t433 ON t1.x = t433.x JOIN (SELECT 1 AS x) t434 ON t1.x = t434.x JOIN (SELECT 1 AS x) t435 ON t1.x = t435.x JOIN (SELECT 1 AS x) t436 ON t1.x = t436.x JOIN (SELECT 1 AS x) t437 ON t1.x = t437.x JOIN (SELECT 1 AS x) t438 ON t1.x = t438.x JOIN (SELECT 1 AS x) t439 ON t1.x = t439.x JOIN (SELECT 1 AS x) t440 ON t1.x = t440.x JOIN (SELECT 1 AS x) t441 ON t1.x = t441.x JOIN (SELECT 1 AS x) t442 ON t1.x = t442.x JOIN (SELECT 1 AS x) t443 ON t1.x = t443.x JOIN (SELECT 1 AS x) t444 ON t1.x = t444.x JOIN (SELECT 1 AS x) t445 ON t1.x = t445.x JOIN (SELECT 1 AS x) t446 ON t1.x = t446.x JOIN (SELECT 1 AS x) t447 ON t1.x = t447.x JOIN (SELECT 1 AS x) t448 ON t1.x = t448.x JOIN (SELECT 1 AS x) t449 ON t1.x = t449.x JOIN (SELECT 1 AS x) t450 ON t1.x = t450.x JOIN (SELECT 1 AS x) t451 ON t1.x = t451.x JOIN (SELECT 1 AS x) t452 ON t1.x = t452.x JOIN (SELECT 1 AS x) t453 ON t1.x = t453.x JOIN (SELECT 1 AS x) t454 ON t1.x = t454.x JOIN (SELECT 1 AS x) t455 ON t1.x = t455.x JOIN (SELECT 1 AS x) t456 ON t1.x = t456.x JOIN (SELECT 1 AS x) t457 ON t1.x = t457.x JOIN (SELECT 1 AS x) t458 ON t1.x = t458.x JOIN (SELECT 1 AS x) t459 ON t1.x = t459.x JOIN (SELECT 1 AS x) t460 ON t1.x = t460.x JOIN (SELECT 1 AS x) t461 ON t1.x = t461.x JOIN (SELECT 1 AS x) t462 ON t1.x = t462.x JOIN (SELECT 1 AS x) t463 ON t1.x = t463.x JOIN (SELECT 1 AS x) t464 ON t1.x = t464.x JOIN (SELECT 1 AS x) t465 ON t1.x = t465.x JOIN (SELECT 1 AS x) t466 ON t1.x = t466.x JOIN (SELECT 1 AS x) t467 ON t1.x = t467.x JOIN (SELECT 1 AS x) t468 ON t1.x = t468.x JOIN (SELECT 1 AS x) t469 ON t1.x = t469.x JOIN (SELECT 1 AS x) t470 ON t1.x = t470.x JOIN (SELECT 1 AS x) t471 ON t1.x = t471.x JOIN (SELECT 1 AS x) t472 ON t1.x = t472.x JOIN (SELECT 1 AS x) t473 ON t1.x = t473.x JOIN (SELECT 1 AS x) t474 ON t1.x = t474.x JOIN (SELECT 1 AS x) t475 ON t1.x = t475.x JOIN (SELECT 1 AS x) t476 ON t1.x = t476.x JOIN (SELECT 1 AS x) t477 ON t1.x = t477.x JOIN (SELECT 1 AS x) t478 ON t1.x = t478.x JOIN (SELECT 1 AS x) t479 ON t1.x = t479.x JOIN (SELECT 1 AS x) t480 ON t1.x = t480.x JOIN (SELECT 1 AS x) t481 ON t1.x = t481.x JOIN (SELECT 1 AS x) t482 ON t1.x = t482.x JOIN (SELECT 1 AS x) t483 ON t1.x = t483.x JOIN (SELECT 1 AS x) t484 ON t1.x = t484.x JOIN (SELECT 1 AS x) t485 ON t1.x = t485.x JOIN (SELECT 1 AS x) t486 ON t1.x = t486.x JOIN (SELECT 1 AS x) t487 ON t1.x = t487.x JOIN (SELECT 1 AS x) t488 ON t1.x = t488.x JOIN (SELECT 1 AS x) t489 ON t1.x = t489.x JOIN (SELECT 1 AS x) t490 ON t1.x = t490.x JOIN (SELECT 1 AS x) t491 ON t1.x = t491.x JOIN (SELECT 1 AS x) t492 ON t1.x = t492.x JOIN (SELECT 1 AS x) t493 ON t1.x = t493.x JOIN (SELECT 1 AS x) t494 ON t1.x = t494.x JOIN (SELECT 1 AS x) t495 ON t1.x = t495.x JOIN (SELECT 1 AS x) t496 ON t1.x = t496.x JOIN (SELECT 1 AS x) t497 ON t1.x = t497.x JOIN (SELECT 1 AS x) t498 ON t1.x = t498.x JOIN (SELECT 1 AS x) t499 ON t1.x = t499.x JOIN (SELECT 1 AS x) t500 ON t1.x = t500.x JOIN (SELECT 1 AS x) t501 ON t1.x = t501.x JOIN (SELECT 1 AS x) t502 ON t1.x = t502.x JOIN (SELECT 1 AS x) t503 ON t1.x = t503.x JOIN (SELECT 1 AS x) t504 ON t1.x = t504.x JOIN (SELECT 1 AS x) t505 ON t1.x = t505.x JOIN (SELECT 1 AS x) t506 ON t1.x = t506.x JOIN (SELECT 1 AS x) t507 ON t1.x = t507.x JOIN (SELECT 1 AS x) t508 ON t1.x = t508.x JOIN (SELECT 1 AS x) t509 ON t1.x = t509.x JOIN (SELECT 1 AS x) t510 ON t1.x = t510.x JOIN (SELECT 1 AS x) t511 ON t1.x = t511.x JOIN (SELECT 1 AS x) t512 ON t1.x = t512.x JOIN (SELECT 1 AS x) t513 ON t1.x = t513.x JOIN (SELECT 1 AS x) t514 ON t1.x = t514.x JOIN (SELECT 1 AS x) t515 ON t1.x = t515.x JOIN (SELECT 1 AS x) t516 ON t1.x = t516.x JOIN (SELECT 1 AS x) t517 ON t1.x = t517.x JOIN (SELECT 1 AS x) t518 ON t1.x = t518.x JOIN (SELECT 1 AS x) t519 ON t1.x = t519.x JOIN (SELECT 1 AS x) t520 ON t1.x = t520.x JOIN (SELECT 1 AS x) t521 ON t1.x = t521.x JOIN (SELECT 1 AS x) t522 ON t1.x = t522.x JOIN (SELECT 1 AS x) t523 ON t1.x = t523.x JOIN (SELECT 1 AS x) t524 ON t1.x = t524.x JOIN (SELECT 1 AS x) t525 ON t1.x = t525.x JOIN (SELECT 1 AS x) t526 ON t1.x = t526.x JOIN (SELECT 1 AS x) t527 ON t1.x = t527.x JOIN (SELECT 1 AS x) t528 ON t1.x = t528.x JOIN (SELECT 1 AS x) t529 ON t1.x = t529.x JOIN (SELECT 1 AS x) t530 ON t1.x = t530.x JOIN (SELECT 1 AS x) t531 ON t1.x = t531.x JOIN (SELECT 1 AS x) t532 ON t1.x = t532.x JOIN (SELECT 1 AS x) t533 ON t1.x = t533.x JOIN (SELECT 1 AS x) t534 ON t1.x = t534.x JOIN (SELECT 1 AS x) t535 ON t1.x = t535.x JOIN (SELECT 1 AS x) t536 ON t1.x = t536.x JOIN (SELECT 1 AS x) t537 ON t1.x = t537.x JOIN (SELECT 1 AS x) t538 ON t1.x = t538.x JOIN (SELECT 1 AS x) t539 ON t1.x = t539.x JOIN (SELECT 1 AS x) t540 ON t1.x = t540.x JOIN (SELECT 1 AS x) t541 ON t1.x = t541.x JOIN (SELECT 1 AS x) t542 ON t1.x = t542.x JOIN (SELECT 1 AS x) t543 ON t1.x = t543.x JOIN (SELECT 1 AS x) t544 ON t1.x = t544.x JOIN (SELECT 1 AS x) t545 ON t1.x = t545.x JOIN (SELECT 1 AS x) t546 ON t1.x = t546.x JOIN (SELECT 1 AS x) t547 ON t1.x = t547.x JOIN (SELECT 1 AS x) t548 ON t1.x = t548.x JOIN (SELECT 1 AS x) t549 ON t1.x = t549.x JOIN (SELECT 1 AS x) t550 ON t1.x = t550.x JOIN (SELECT 1 AS x) t551 ON t1.x = t551.x JOIN (SELECT 1 AS x) t552 ON t1.x = t552.x JOIN (SELECT 1 AS x) t553 ON t1.x = t553.x JOIN (SELECT 1 AS x) t554 ON t1.x = t554.x JOIN (SELECT 1 AS x) t555 ON t1.x = t555.x JOIN (SELECT 1 AS x) t556 ON t1.x = t556.x JOIN (SELECT 1 AS x) t557 ON t1.x = t557.x JOIN (SELECT 1 AS x) t558 ON t1.x = t558.x JOIN (SELECT 1 AS x) t559 ON t1.x = t559.x JOIN (SELECT 1 AS x) t560 ON t1.x = t560.x JOIN (SELECT 1 AS x) t561 ON t1.x = t561.x JOIN (SELECT 1 AS x) t562 ON t1.x = t562.x JOIN (SELECT 1 AS x) t563 ON t1.x = t563.x JOIN (SELECT 1 AS x) t564 ON t1.x = t564.x JOIN (SELECT 1 AS x) t565 ON t1.x = t565.x JOIN (SELECT 1 AS x) t566 ON t1.x = t566.x JOIN (SELECT 1 AS x) t567 ON t1.x = t567.x JOIN (SELECT 1 AS x) t568 ON t1.x = t568.x JOIN (SELECT 1 AS x) t569 ON t1.x = t569.x JOIN (SELECT 1 AS x) t570 ON t1.x = t570.x JOIN (SELECT 1 AS x) t571 ON t1.x = t571.x JOIN (SELECT 1 AS x) t572 ON t1.x = t572.x JOIN (SELECT 1 AS x) t573 ON t1.x = t573.x JOIN (SELECT 1 AS x) t574 ON t1.x = t574.x JOIN (SELECT 1 AS x) t575 ON t1.x = t575.x JOIN (SELECT 1 AS x) t576 ON t1.x = t576.x JOIN (SELECT 1 AS x) t577 ON t1.x = t577.x JOIN (SELECT 1 AS x) t578 ON t1.x = t578.x JOIN (SELECT 1 AS x) t579 ON t1.x = t579.x JOIN (SELECT 1 AS x) t580 ON t1.x = t580.x JOIN (SELECT 1 AS x) t581 ON t1.x = t581.x JOIN (SELECT 1 AS x) t582 ON t1.x = t582.x JOIN (SELECT 1 AS x) t583 ON t1.x = t583.x JOIN (SELECT 1 AS x) t584 ON t1.x = t584.x JOIN (SELECT 1 AS x) t585 ON t1.x = t585.x JOIN (SELECT 1 AS x) t586 ON t1.x = t586.x JOIN (SELECT 1 AS x) t587 ON t1.x = t587.x JOIN (SELECT 1 AS x) t588 ON t1.x = t588.x JOIN (SELECT 1 AS x) t589 ON t1.x = t589.x JOIN (SELECT 1 AS x) t590 ON t1.x = t590.x JOIN (SELECT 1 AS x) t591 ON t1.x = t591.x JOIN (SELECT 1 AS x) t592 ON t1.x = t592.x JOIN (SELECT 1 AS x) t593 ON t1.x = t593.x JOIN (SELECT 1 AS x) t594 ON t1.x = t594.x JOIN (SELECT 1 AS x) t595 ON t1.x = t595.x JOIN (SELECT 1 AS x) t596 ON t1.x = t596.x JOIN (SELECT 1 AS x) t597 ON t1.x = t597.x JOIN (SELECT 1 AS x) t598 ON t1.x = t598.x JOIN (SELECT 1 AS x) t599 ON t1.x = t599.x JOIN (SELECT 1 AS x) t600 ON t1.x = t600.x JOIN (SELECT 1 AS x) t601 ON t1.x = t601.x JOIN (SELECT 1 AS x) t602 ON t1.x = t602.x JOIN (SELECT 1 AS x) t603 ON t1.x = t603.x JOIN (SELECT 1 AS x) t604 ON t1.x = t604.x JOIN (SELECT 1 AS x) t605 ON t1.x = t605.x JOIN (SELECT 1 AS x) t606 ON t1.x = t606.x JOIN (SELECT 1 AS x) t607 ON t1.x = t607.x JOIN (SELECT 1 AS x) t608 ON t1.x = t608.x JOIN (SELECT 1 AS x) t609 ON t1.x = t609.x JOIN (SELECT 1 AS x) t610 ON t1.x = t610.x JOIN (SELECT 1 AS x) t611 ON t1.x = t611.x JOIN (SELECT 1 AS x) t612 ON t1.x = t612.x JOIN (SELECT 1 AS x) t613 ON t1.x = t613.x JOIN (SELECT 1 AS x) t614 ON t1.x = t614.x JOIN (SELECT 1 AS x) t615 ON t1.x = t615.x JOIN (SELECT 1 AS x) t616 ON t1.x = t616.x JOIN (SELECT 1 AS x) t617 ON t1.x = t617.x JOIN (SELECT 1 AS x) t618 ON t1.x = t618.x JOIN (SELECT 1 AS x) t619 ON t1.x = t619.x JOIN (SELECT 1 AS x) t620 ON t1.x = t620.x JOIN (SELECT 1 AS x) t621 ON t1.x = t621.x JOIN (SELECT 1 AS x) t622 ON t1.x = t622.x JOIN (SELECT 1 AS x) t623 ON t1.x = t623.x JOIN (SELECT 1 AS x) t624 ON t1.x = t624.x JOIN (SELECT 1 AS x) t625 ON t1.x = t625.x JOIN (SELECT 1 AS x) t626 ON t1.x = t626.x JOIN (SELECT 1 AS x) t627 ON t1.x = t627.x JOIN (SELECT 1 AS x) t628 ON t1.x = t628.x JOIN (SELECT 1 AS x) t629 ON t1.x = t629.x JOIN (SELECT 1 AS x) t630 ON t1.x = t630.x JOIN (SELECT 1 AS x) t631 ON t1.x = t631.x JOIN (SELECT 1 AS x) t632 ON t1.x = t632.x JOIN (SELECT 1 AS x) t633 ON t1.x = t633.x JOIN (SELECT 1 AS x) t634 ON t1.x = t634.x JOIN (SELECT 1 AS x) t635 ON t1.x = t635.x JOIN (SELECT 1 AS x) t636 ON t1.x = t636.x JOIN (SELECT 1 AS x) t637 ON t1.x = t637.x JOIN (SELECT 1 AS x) t638 ON t1.x = t638.x JOIN (SELECT 1 AS x) t639 ON t1.x = t639.x JOIN (SELECT 1 AS x) t640 ON t1.x = t640.x JOIN (SELECT 1 AS x) t641 ON t1.x = t641.x JOIN (SELECT 1 AS x) t642 ON t1.x = t642.x JOIN (SELECT 1 AS x) t643 ON t1.x = t643.x JOIN (SELECT 1 AS x) t644 ON t1.x = t644.x JOIN (SELECT 1 AS x) t645 ON t1.x = t645.x JOIN (SELECT 1 AS x) t646 ON t1.x = t646.x JOIN (SELECT 1 AS x) t647 ON t1.x = t647.x JOIN (SELECT 1 AS x) t648 ON t1.x = t648.x JOIN (SELECT 1 AS x) t649 ON t1.x = t649.x JOIN (SELECT 1 AS x) t650 ON t1.x = t650.x JOIN (SELECT 1 AS x) t651 ON t1.x = t651.x JOIN (SELECT 1 AS x) t652 ON t1.x = t652.x JOIN (SELECT 1 AS x) t653 ON t1.x = t653.x JOIN (SELECT 1 AS x) t654 ON t1.x = t654.x JOIN (SELECT 1 AS x) t655 ON t1.x = t655.x JOIN (SELECT 1 AS x) t656 ON t1.x = t656.x JOIN (SELECT 1 AS x) t657 ON t1.x = t657.x JOIN (SELECT 1 AS x) t658 ON t1.x = t658.x JOIN (SELECT 1 AS x) t659 ON t1.x = t659.x JOIN (SELECT 1 AS x) t660 ON t1.x = t660.x JOIN (SELECT 1 AS x) t661 ON t1.x = t661.x JOIN (SELECT 1 AS x) t662 ON t1.x = t662.x JOIN (SELECT 1 AS x) t663 ON t1.x = t663.x JOIN (SELECT 1 AS x) t664 ON t1.x = t664.x JOIN (SELECT 1 AS x) t665 ON t1.x = t665.x JOIN (SELECT 1 AS x) t666 ON t1.x = t666.x 2025-04-02 01:51:11 ) 2025-04-02 01:51:11 , result: 2025-04-02 01:51:11 2025-04-02 01:51:11 2025-04-02 01:51:11 2025-04-02 01:51:11 stdout: 2025-04-02 01:51:11 2025-04-02 01:51:11 2025-04-02 01:51:11 Settings used in the test: --max_insert_threads 1 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 8079899 --max_read_buffer_size 710659 --prefer_localhost_replica 0 --max_block_size 71892 --max_joined_block_size_rows 36349 --max_threads 1 --optimize_append_index 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 83 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 41984647 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 4072777496 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 0 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 12 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 2297524826 --min_compress_block_size 1048255 --max_compress_block_size 1495863 --merge_tree_compact_parts_min_granules_to_multibuffer_read 35 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 9965736 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone America/Hermosillo --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.58 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 10 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 0 --query_plan_join_swap_table auto --output_format_native_write_json_as_string 1 --enable_vertical_final 0 2025-04-02 01:51:11 2025-04-02 01:51:11 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.5222964672897304 --prefer_fetch_merged_part_size_threshold 1663329126 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1774195431 --index_granularity_bytes 25155563 --merge_max_block_size 2619 --index_granularity 19539 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 82132 --primary_key_compress_block_size 57999 --replace_long_file_name_to_hash 0 --max_file_name_length 0 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 243186409 --compact_parts_max_granules_to_buffer 1 --compact_parts_merge_max_bytes_to_prefetch_part 21309571 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 58 --old_parts_lifetime 480 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 0 --use_primary_key_cache 0 --prewarm_primary_key_cache 1 2025-04-02 01:51:11 2025-04-02 01:51:11 Database: test_ev5auitj 2025-04-02 01:51:11 Process Process-6: 2025-04-02 01:51:11 Traceback (most recent call last): 2025-04-02 01:51:11 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-02 01:51:11 self.run() 2025-04-02 01:51:11 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-02 01:51:11 self._target(*self._args, **self._kwargs) 2025-04-02 01:51:11 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-02 01:51:11 return run_tests_array(*args, **kwargs) 2025-04-02 01:51:11 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-02 01:51:11 stop_tests() 2025-04-02 01:51:11 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-02 01:51:11 cleanup_child_processes(os.getpid()) 2025-04-02 01:51:11 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-02 01:51:11 child_pgid = os.getpgid(child) 2025-04-02 01:51:11 ProcessLookupError: [Errno 3] No such process 2025-04-02 01:51:11 Child processes of 1386: 2025-04-02 01:51:11 19612 /bin/sh -c pgrep --parent 1386 -a 2025-04-02 01:51:12 03228_clickhouse_local_copy_argument: [ FAIL ] 12.61 sec. 2025-04-02 01:51:12 Reason: server died 2025-04-02 01:51:12 ConnectionRefusedError 2025-04-02 01:51:12 [Errno 111] Connection refused 2025-04-02 01:51:12 File "/usr/bin/clickhouse-test", line 1854, in run 2025-04-02 01:51:12 self._cleanup(result.status == TestStatus.OK) 2025-04-02 01:51:12 2025-04-02 01:51:12 File "/usr/bin/clickhouse-test", line 1917, in _cleanup 2025-04-02 01:51:12 self._cleanup_database(args, timeout) 2025-04-02 01:51:12 2025-04-02 01:51:12 File "/usr/bin/clickhouse-test", line 1951, in _cleanup_database 2025-04-02 01:51:12 clickhouse_execute( 2025-04-02 01:51:12 2025-04-02 01:51:12 File "/usr/bin/clickhouse-test", line 334, in clickhouse_execute 2025-04-02 01:51:12 return clickhouse_execute_http( 2025-04-02 01:51:12 2025-04-02 01:51:12 File "/usr/bin/clickhouse-test", line 315, in clickhouse_execute_http 2025-04-02 01:51:12 raise ex 2025-04-02 01:51:12 2025-04-02 01:51:12 File "/usr/bin/clickhouse-test", line 304, in clickhouse_execute_http 2025-04-02 01:51:12 client.request( 2025-04-02 01:51:12 2025-04-02 01:51:12 File "/usr/lib/python3.10/http/client.py", line 1283, in request 2025-04-02 01:51:12 self._send_request(method, url, body, headers, encode_chunked) 2025-04-02 01:51:12 2025-04-02 01:51:12 File "/usr/lib/python3.10/http/client.py", line 1329, in _send_request 2025-04-02 01:51:12 self.endheaders(body, encode_chunked=encode_chunked) 2025-04-02 01:51:12 2025-04-02 01:51:12 File "/usr/lib/python3.10/http/client.py", line 1278, in endheaders 2025-04-02 01:51:12 self._send_output(message_body, encode_chunked=encode_chunked) 2025-04-02 01:51:12 2025-04-02 01:51:12 File "/usr/lib/python3.10/http/client.py", line 1038, in _send_output 2025-04-02 01:51:12 self.send(msg) 2025-04-02 01:51:12 2025-04-02 01:51:12 Settings used in the test: --max_insert_threads 3 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 4022302 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 1601350 --max_read_buffer_size 878906 --prefer_localhost_replica 0 --max_block_size 23566 --max_joined_block_size_rows 57218 --max_threads 3 --optimize_append_index 0 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 17 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 3757783 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 1 --min_bytes_to_use_mmap_io 5164012441 --local_filesystem_read_method pread_threadpool --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 100 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 25 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_before_remerge_sort 2714553333 --min_compress_block_size 304326 --max_compress_block_size 2868791 --merge_tree_compact_parts_min_granules_to_multibuffer_read 70 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 927574 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 0 --session_timezone Africa/Khartoum --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.79 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 1 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table false --output_format_native_write_json_as_string 1 --enable_vertical_final 1 2025-04-02 01:51:12 2025-04-02 01:51:12 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 811587 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 6827104656 --index_granularity_bytes 12321663 --merge_max_block_size 8061 --index_granularity 10323 --min_bytes_for_wide_part 0 --marks_compress_block_size 97154 --primary_key_compress_block_size 33442 --replace_long_file_name_to_hash 1 --max_file_name_length 12 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 205930182 --compact_parts_max_granules_to_buffer 109 --compact_parts_merge_max_bytes_to_prefetch_part 16445177 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 0 --old_parts_lifetime 383 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --use_primary_key_cache 0 --prewarm_primary_key_cache 1 2025-04-02 01:51:12 2025-04-02 01:51:12 Database: test_gm5rppbl 2025-04-02 01:51:12 Process Process-9: 2025-04-02 01:51:12 Traceback (most recent call last): 2025-04-02 01:51:12 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-02 01:51:12 self.run() 2025-04-02 01:51:12 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-02 01:51:12 self._target(*self._args, **self._kwargs) 2025-04-02 01:51:12 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-02 01:51:12 return run_tests_array(*args, **kwargs) 2025-04-02 01:51:12 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-02 01:51:12 stop_tests() 2025-04-02 01:51:12 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-02 01:51:12 cleanup_child_processes(os.getpid()) 2025-04-02 01:51:12 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-02 01:51:12 child_pgid = os.getpgid(child) 2025-04-02 01:51:12 ProcessLookupError: [Errno 3] No such process 2025-04-02 01:51:12 Child processes of 1397: 2025-04-02 01:51:12 19628 /bin/sh -c pgrep --parent 1397 -a 2025-04-02 01:51:12 01666_merge_tree_max_query_limit: [ FAIL ] 10.77 sec. 2025-04-02 01:51:12 Reason: return code: 1 2025-04-02 01:51:12 Code: 210. DB::NetException: Connection reset by peer, while reading from socket (peer: [::1]:9000, local: [::1]:39154): (localhost:9000, ::1, local address: [::1]:39154). (NETWORK_ERROR) 2025-04-02 01:51:12 2025-04-02 01:51:12 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-02 01:51:12 2025-04-02 01:51:12 , result: 2025-04-02 01:51:12 2025-04-02 01:51:12 Spin up a long running query 2025-04-02 01:51:12 Check if another query with some marks to read is throttled 2025-04-02 01:51:12 yes 2025-04-02 01:51:12 Check if another query with less marks to read is passed 2025-04-02 01:51:12 0 100 2025-04-02 01:51:12 Modify min_marks_to_honor_max_concurrent_queries to 1 2025-04-02 01:51:12 Check if another query with less marks to read is throttled 2025-04-02 01:51:12 yes 2025-04-02 01:51:12 Modify max_concurrent_queries to 2 2025-04-02 01:51:12 Check if another query is passed 2025-04-02 01:51:12 Modify max_concurrent_queries back to 1 2025-04-02 01:51:12 Check if another query with less marks to read is throttled 2025-04-02 01:51:12 Expected error code: 202 but got: 210 2025-04-02 01:51:12 2025-04-02 01:51:12 stdout: 2025-04-02 01:51:12 Spin up a long running query 2025-04-02 01:51:12 Check if another query with some marks to read is throttled 2025-04-02 01:51:12 yes 2025-04-02 01:51:12 Check if another query with less marks to read is passed 2025-04-02 01:51:12 0 100 2025-04-02 01:51:12 Modify min_marks_to_honor_max_concurrent_queries to 1 2025-04-02 01:51:12 Check if another query with less marks to read is throttled 2025-04-02 01:51:12 yes 2025-04-02 01:51:12 Modify max_concurrent_queries to 2 2025-04-02 01:51:12 Check if another query is passed 2025-04-02 01:51:12 Modify max_concurrent_queries back to 1 2025-04-02 01:51:12 Check if another query with less marks to read is throttled 2025-04-02 01:51:12 Expected error code: 202 but got: 210 2025-04-02 01:51:12 2025-04-02 01:51:12 2025-04-02 01:51:12 Settings used in the test: --max_insert_threads 1 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 1726219 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 14284667 --max_read_buffer_size 515839 --prefer_localhost_replica 1 --max_block_size 21035 --max_joined_block_size_rows 55454 --max_threads 2 --optimize_append_index 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 0 --optimize_or_like_chain 1 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 59 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 47720128 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method mmap --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 100 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 6 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 2926578631 --min_compress_block_size 571150 --max_compress_block_size 1983316 --merge_tree_compact_parts_min_granules_to_multibuffer_read 104 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 3787110 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone Africa/Khartoum --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.22 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 10 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table auto --output_format_native_write_json_as_string 0 --enable_vertical_final 0 2025-04-02 01:51:12 2025-04-02 01:51:12 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 140296331 --index_granularity_bytes 2642776 --merge_max_block_size 20799 --index_granularity 37077 --min_bytes_for_wide_part 341597940 --marks_compress_block_size 94123 --primary_key_compress_block_size 87930 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 67748344 --compact_parts_max_granules_to_buffer 148 --compact_parts_merge_max_bytes_to_prefetch_part 30840485 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 0 --old_parts_lifetime 10 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --use_primary_key_cache 1 --prewarm_primary_key_cache 1 2025-04-02 01:51:12 2025-04-02 01:51:12 Database: test_kna9ybmp 2025-04-02 01:51:14 01825_type_json_ghdata_insert_select: [ FAIL ] 21.14 sec. 2025-04-02 01:51:14 Reason: return code: 210 2025-04-02 01:51:14 Code: 210. DB::NetException: Connection reset by peer, while reading from socket (peer: [::1]:9000, local: [::1]:39142): (localhost:9000, ::1, local address: [::1]:39142). (NETWORK_ERROR) 2025-04-02 01:51:14 2025-04-02 01:51:14 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-02 01:51:14 2025-04-02 01:51:14 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-02 01:51:14 2025-04-02 01:51:14 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-02 01:51:14 2025-04-02 01:51:14 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-02 01:51:14 2025-04-02 01:51:14 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 2025-04-02 01:51:14 2025-04-02 01:51:14 , result: 2025-04-02 01:51:14 2025-04-02 01:51:14 2025-04-02 01:51:14 2025-04-02 01:51:14 stdout: 2025-04-02 01:51:14 2025-04-02 01:51:14 2025-04-02 01:51:14 Settings used in the test: --max_insert_threads 2 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 12203089 --max_read_buffer_size 807063 --prefer_localhost_replica 0 --max_block_size 86686 --max_joined_block_size_rows 89319 --max_threads 1 --optimize_append_index 0 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 1 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 8 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 17890427 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 2598138880 --min_bytes_to_use_mmap_io 3447775889 --local_filesystem_read_method io_uring --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 2 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 6 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10528874415 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 760663336 --min_compress_block_size 282605 --max_compress_block_size 2578973 --merge_tree_compact_parts_min_granules_to_multibuffer_read 65 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 1735809 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 0 --session_timezone Africa/Juba --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.29 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 1 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 1 --max_parsing_threads 10 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table false --output_format_native_write_json_as_string 1 --enable_vertical_final 0 2025-04-02 01:51:14 2025-04-02 01:51:14 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 674064 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 7310451742 --index_granularity_bytes 28161328 --merge_max_block_size 14677 --index_granularity 60458 --min_bytes_for_wide_part 229634407 --marks_compress_block_size 8794 --primary_key_compress_block_size 48736 --replace_long_file_name_to_hash 0 --max_file_name_length 0 --min_bytes_for_full_part_storage 13019423 --compact_parts_max_bytes_to_buffer 490759459 --compact_parts_max_granules_to_buffer 47 --compact_parts_merge_max_bytes_to_prefetch_part 8485142 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 100 --old_parts_lifetime 480 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 0 --use_primary_key_cache 0 --prewarm_primary_key_cache 0 2025-04-02 01:51:14 2025-04-02 01:51:14 Database: test_rkwh756i 2025-04-02 01:51:21 01356_initialize_aggregation: [ FAIL ] 0.00 sec. 2025-04-02 01:51:21 Reason: server died 2025-04-02 01:51:21 Server does not respond to health check 2025-04-02 01:51:21 2025-04-02 01:51:21 Process Process-8: 2025-04-02 01:51:21 Traceback (most recent call last): 2025-04-02 01:51:21 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-02 01:51:21 self.run() 2025-04-02 01:51:21 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-02 01:51:21 self._target(*self._args, **self._kwargs) 2025-04-02 01:51:21 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-02 01:51:21 return run_tests_array(*args, **kwargs) 2025-04-02 01:51:21 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-02 01:51:21 stop_tests() 2025-04-02 01:51:21 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-02 01:51:21 cleanup_child_processes(os.getpid()) 2025-04-02 01:51:21 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-02 01:51:21 child_pgid = os.getpgid(child) 2025-04-02 01:51:21 ProcessLookupError: [Errno 3] No such process 2025-04-02 01:51:21 Child processes of 1392: 2025-04-02 01:51:21 19785 /bin/sh -c pgrep --parent 1392 -a 2025-04-02 01:51:21 02967_analyzer_fuzz: [ FAIL ] 0.00 sec. 2025-04-02 01:51:21 Reason: server died 2025-04-02 01:51:21 Server does not respond to health check 2025-04-02 01:51:21 2025-04-02 01:51:21 Process Process-4: 2025-04-02 01:51:21 Traceback (most recent call last): 2025-04-02 01:51:21 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-02 01:51:21 self.run() 2025-04-02 01:51:21 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-02 01:51:21 self._target(*self._args, **self._kwargs) 2025-04-02 01:51:21 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-02 01:51:21 return run_tests_array(*args, **kwargs) 2025-04-02 01:51:21 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-02 01:51:21 stop_tests() 2025-04-02 01:51:21 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-02 01:51:21 cleanup_child_processes(os.getpid()) 2025-04-02 01:51:21 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-02 01:51:21 child_pgid = os.getpgid(child) 2025-04-02 01:51:21 ProcessLookupError: [Errno 3] No such process 2025-04-02 01:51:21 Child processes of 1381: 2025-04-02 01:51:21 19791 /bin/sh -c pgrep --parent 1381 -a 2025-04-02 01:51:21 00818_alias_bug_4110: [ FAIL ] 0.00 sec. 2025-04-02 01:51:21 Reason: server died 2025-04-02 01:51:21 Server does not respond to health check 2025-04-02 01:51:21 2025-04-02 01:51:21 Process Process-3: 2025-04-02 01:51:21 Traceback (most recent call last): 2025-04-02 01:51:21 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-02 01:51:21 self.run() 2025-04-02 01:51:21 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-02 01:51:21 self._target(*self._args, **self._kwargs) 2025-04-02 01:51:21 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-02 01:51:21 return run_tests_array(*args, **kwargs) 2025-04-02 01:51:21 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-02 01:51:21 stop_tests() 2025-04-02 01:51:21 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-02 01:51:21 cleanup_child_processes(os.getpid()) 2025-04-02 01:51:21 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-02 01:51:21 child_pgid = os.getpgid(child) 2025-04-02 01:51:21 ProcessLookupError: [Errno 3] No such process 2025-04-02 01:51:21 Child processes of 1380: 2025-04-02 01:51:21 19797 /bin/sh -c pgrep --parent 1380 -a 2025-04-02 01:51:22 02903_client_insert_in_background: [ FAIL ] 0.00 sec. 2025-04-02 01:51:22 Reason: server died 2025-04-02 01:51:22 Server does not respond to health check 2025-04-02 01:51:22 2025-04-02 01:51:22 Process Process-10: 2025-04-02 01:51:23 Traceback (most recent call last): 2025-04-02 01:51:23 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-02 01:51:23 self.run() 2025-04-02 01:51:23 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-02 01:51:23 self._target(*self._args, **self._kwargs) 2025-04-02 01:51:23 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-02 01:51:23 return run_tests_array(*args, **kwargs) 2025-04-02 01:51:23 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-02 01:51:23 stop_tests() 2025-04-02 01:51:23 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-02 01:51:23 cleanup_child_processes(os.getpid()) 2025-04-02 01:51:23 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-02 01:51:23 child_pgid = os.getpgid(child) 2025-04-02 01:51:23 ProcessLookupError: [Errno 3] No such process 2025-04-02 01:51:23 Child processes of 1400: 2025-04-02 01:51:23 19803 /bin/sh -c pgrep --parent 1400 -a 2025-04-02 01:51:24 01442_merge_detach_attach_long: [ FAIL ] 0.00 sec. 2025-04-02 01:51:24 Reason: server died 2025-04-02 01:51:24 Server does not respond to health check 2025-04-02 01:51:24 2025-04-02 01:51:24 Process Process-7: 2025-04-02 01:51:24 Traceback (most recent call last): 2025-04-02 01:51:24 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-02 01:51:24 self.run() 2025-04-02 01:51:24 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-02 01:51:24 self._target(*self._args, **self._kwargs) 2025-04-02 01:51:24 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-02 01:51:24 return run_tests_array(*args, **kwargs) 2025-04-02 01:51:24 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-02 01:51:24 stop_tests() 2025-04-02 01:51:24 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-02 01:51:24 cleanup_child_processes(os.getpid()) 2025-04-02 01:51:24 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-02 01:51:24 child_pgid = os.getpgid(child) 2025-04-02 01:51:24 ProcessLookupError: [Errno 3] No such process 2025-04-02 01:51:24 Child processes of 1390: 2025-04-02 01:51:24 19809 /bin/sh -c pgrep --parent 1390 -a 2025-04-02 01:51:28 02521_tsv_csv_custom_header_detection: [ FAIL ] 53.34 sec. 2025-04-02 01:51:28 Reason: server died 2025-04-02 01:51:28 ConnectionRefusedError 2025-04-02 01:51:28 [Errno 111] Connection refused 2025-04-02 01:51:28 File "/usr/bin/clickhouse-test", line 1854, in run 2025-04-02 01:51:28 self._cleanup(result.status == TestStatus.OK) 2025-04-02 01:51:28 2025-04-02 01:51:28 File "/usr/bin/clickhouse-test", line 1917, in _cleanup 2025-04-02 01:51:28 self._cleanup_database(args, timeout) 2025-04-02 01:51:28 2025-04-02 01:51:28 File "/usr/bin/clickhouse-test", line 1951, in _cleanup_database 2025-04-02 01:51:28 clickhouse_execute( 2025-04-02 01:51:28 2025-04-02 01:51:28 File "/usr/bin/clickhouse-test", line 334, in clickhouse_execute 2025-04-02 01:51:28 return clickhouse_execute_http( 2025-04-02 01:51:28 2025-04-02 01:51:28 File "/usr/bin/clickhouse-test", line 315, in clickhouse_execute_http 2025-04-02 01:51:28 raise ex 2025-04-02 01:51:28 2025-04-02 01:51:28 File "/usr/bin/clickhouse-test", line 304, in clickhouse_execute_http 2025-04-02 01:51:28 client.request( 2025-04-02 01:51:28 2025-04-02 01:51:28 File "/usr/lib/python3.10/http/client.py", line 1283, in request 2025-04-02 01:51:28 self._send_request(method, url, body, headers, encode_chunked) 2025-04-02 01:51:28 2025-04-02 01:51:28 File "/usr/lib/python3.10/http/client.py", line 1329, in _send_request 2025-04-02 01:51:28 self.endheaders(body, encode_chunked=encode_chunked) 2025-04-02 01:51:28 2025-04-02 01:51:28 File "/usr/lib/python3.10/http/client.py", line 1278, in endheaders 2025-04-02 01:51:28 self._send_output(message_body, encode_chunked=encode_chunked) 2025-04-02 01:51:28 2025-04-02 01:51:28 File "/usr/lib/python3.10/http/client.py", line 1038, in _send_output 2025-04-02 01:51:28 self.send(msg) 2025-04-02 01:51:28 2025-04-02 01:51:28 Settings used in the test: --max_insert_threads 3 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 45310529 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 5183551 --max_read_buffer_size 793626 --prefer_localhost_replica 1 --max_block_size 51802 --max_joined_block_size_rows 76094 --max_threads 1 --optimize_append_index 0 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 21 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 42594639 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 5 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 16Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 3 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 2023115740 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 1618001977 --min_compress_block_size 1656561 --max_compress_block_size 720386 --merge_tree_compact_parts_min_granules_to_multibuffer_read 124 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 9627659 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone Mexico/BajaSur --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.19 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 1 --cross_join_min_bytes_to_compress 1 --min_external_table_block_size_bytes 1 --max_parsing_threads 0 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 0 --query_plan_join_swap_table false --output_format_native_write_json_as_string 0 --enable_vertical_final 0 2025-04-02 01:51:28 2025-04-02 01:51:28 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 3575717884 --index_granularity_bytes 31046548 --merge_max_block_size 14636 --index_granularity 19820 --min_bytes_for_wide_part 181752891 --marks_compress_block_size 49465 --primary_key_compress_block_size 9892 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 189674525 --compact_parts_max_granules_to_buffer 256 --compact_parts_merge_max_bytes_to_prefetch_part 27234366 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 20 --old_parts_lifetime 348 --prewarm_mark_cache 0 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 0 --use_primary_key_cache 1 --prewarm_primary_key_cache 0 2025-04-02 01:51:28 2025-04-02 01:51:28 Database: test_p84ktgz0 2025-04-02 01:51:28 Process Process-5: 2025-04-02 01:51:28 Traceback (most recent call last): 2025-04-02 01:51:28 File "/usr/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap 2025-04-02 01:51:28 self.run() 2025-04-02 01:51:28 File "/usr/lib/python3.10/multiprocessing/process.py", line 108, in run 2025-04-02 01:51:28 self._target(*self._args, **self._kwargs) 2025-04-02 01:51:28 File "/usr/bin/clickhouse-test", line 2626, in run_tests_process 2025-04-02 01:51:28 return run_tests_array(*args, **kwargs) 2025-04-02 01:51:28 File "/usr/bin/clickhouse-test", line 2407, in run_tests_array 2025-04-02 01:51:28 stop_tests() 2025-04-02 01:51:28 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-02 01:51:28 cleanup_child_processes(os.getpid()) 2025-04-02 01:51:28 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-02 01:51:28 child_pgid = os.getpgid(child) 2025-04-02 01:51:28 ProcessLookupError: [Errno 3] No such process 2025-04-02 01:51:28 Child processes of 1383: 2025-04-02 01:51:28 19815 /bin/sh -c pgrep --parent 1383 -a 2025-04-02 02:04:12 Hung check failed: [Errno 111] Connection refused 2025-04-02 02:04:12 Server died, terminating all processes... 2025-04-02 02:04:12 Running 130 stateless tests (MainProcess). 2025-04-02 02:04:12 Child processes of 1364: 2025-04-02 02:04:12 1367 python3 /usr/bin/clickhouse-test --testname --shard --zookeeper --check-zookeeper-session --hung-check --print-time --no-drop-if-fail --capture-client-stacktrace --queries /repo/tests/queries --test-runs 1 --hung-check --print-time --jobs 8 --run-by-hash-num 2 --run-by-hash-total 4 --report-logs-stats 2025-04-02 02:04:12 1373 python3 /usr/bin/clickhouse-test --testname --shard --zookeeper --check-zookeeper-session --hung-check --print-time --no-drop-if-fail --capture-client-stacktrace --queries /repo/tests/queries --test-runs 1 --hung-check --print-time --jobs 8 --run-by-hash-num 2 --run-by-hash-total 4 --report-logs-stats 2025-04-02 02:04:12 19823 /bin/sh -c pgrep --parent 1364 -a 2025-04-02 02:04:12 Traceback (most recent call last): 2025-04-02 02:04:12 File "/usr/bin/clickhouse-test", line 3716, in 2025-04-02 02:04:12 main(args) 2025-04-02 02:04:12 File "/usr/bin/clickhouse-test", line 3063, in main 2025-04-02 02:04:12 total_tests_run += do_run_tests(args.jobs, test_suite) 2025-04-02 02:04:12 File "/usr/bin/clickhouse-test", line 2697, in do_run_tests 2025-04-02 02:04:12 run_tests_array( 2025-04-02 02:04:12 File "/usr/bin/clickhouse-test", line 2343, in run_tests_array 2025-04-02 02:04:12 stop_tests() 2025-04-02 02:04:12 File "/usr/bin/clickhouse-test", line 452, in stop_tests 2025-04-02 02:04:12 cleanup_child_processes(os.getpid()) 2025-04-02 02:04:12 File "/usr/bin/clickhouse-test", line 440, in cleanup_child_processes 2025-04-02 02:04:12 child_pgid = os.getpgid(child) 2025-04-02 02:04:12 ProcessLookupError: [Errno 3] No such process